Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivottable which shows quaterly information about products and I need the slope from one quater to another.
Example table:
Product Q4/2019 Q3/2019 Q2/2019
A 5 4 3
I tried
LinEst_M(count(distinct valueNumber), after(count(distinct valueNumber)))
But QlikSense throws an error: Nested aggregation not allowed....
Any hints?
Perhaps with TOTAL Qualifier?
LinEst_M(TOTAL count(distinct valueNumber), after(count(distinct valueNumber)))