If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Below is a straight table I am working on showing the total of pieces per month using the expression:
Under it I have just a simple text box showing the average per month;=ceil((NUM(sum(Pieces)))/12)
How do I add a row to my table to show the average pieces based on the months above?
Similar to my expression but instead of dividing by 12 months, divide by months selected/above?
My problem is if I select 2 months, my average still divides by 12, not 2.
It can be solved using 'GetSelectedCount()' function. Use the below expression in the text box.
I tried this and it was working.
View solution in original post