Solved: How to perform aggregation - Qlik Community

vikasshana · ‎2025-02-13

Hi,

I've below data.

I'm trying to create chart with As Of Month, sum(Num) and Sum(Den) and end up with the below chart

As Of Month	sum(Num)	sum(Den)
2025001	0	0

But expecting below output

rubenmarin · ‎2025-02-13

Hi, so you want to see the same values in the dimension? Maybe using Dual([As Of Month],Period) as calculated dimension.

It could be Dual([As Of Month],Num#(Period,0)) if Period is a string.

rubenmarin · ‎2025-02-13

Hi, so you want to see the same values in the dimension? Maybe using Dual([As Of Month],Period) as calculated dimension.

It could be Dual([As Of Month],Num#(Period,0)) if Period is a string.

vikasshana · ‎2025-02-14

thank you, it is working..!!!

How to perform aggregation