This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi, I have the following table, and I want to calculate Value, grouped by Time Period and Dim2. I tried with: sum(Aggr(SUM(Value), [Time Period],Dim2)) but it didn't work.
How do I calculate the '???' column? Can anyone pls help?
Thanks in advance,
sum(Aggr(SUM(total <[Time Period]> Value), [Time Period],Dim1,Dim2))
View solution in original post
Try incorporating NODISTINCT in aggr() like:
sum(Aggr(NODISTINCT SUM(Value), [Time Period],Dim2))
Worked perfect! Thanks a lot for your help
In fact, you would not probably require aggr() here. Just try:
SUM(total <[Time Period]> Value)
I tried with both expressions, but they didn't work for me
It works with me:
In my example, I have filtered Time Period '201901' and '201902', and Dim2='Europe' but I have other Time Periods (201903, 201904 ...) and other Dim1 (America, Africa ...) in my dataset.
Could that be the reason maybe?
Filtering period should not be the issue, however, different values in dim2 should be one. If you need output wrt the values in dim2, you have to include dim2 too in the expression.
Perfect! Thanks for your help Tresesco.