如何在Qlik Sense中将Con_TYPE字段归类为两行展示

如果需要从数据表中动态统计分类后的数量，可以使用CASE语句结合分组聚合：

SELECT
  CASE
    WHEN Con_TYPE = 'fiberoptic' THEN 'fiberoptic'
    ELSE 'others'
  END AS connection_type,
  COUNT(*) AS count
FROM your_table_name  -- 替换成你的实际表名
GROUP BY connection_type;

如果已经明确数值（fiberoptic对应5，others对应115），只是需要固定展示这两行结果，可以用UNION ALL直接构造结果：

SELECT 'fiberoptic' AS connection_type, 5 AS count
UNION ALL
SELECT 'others' AS connection_type, 115 AS count;

内容的提问来源于stack exchange，提问作者Javid Hesenov