Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Slope of a Pivot

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?

1 Reply
Anil_Babu_Samineni

Perhaps with TOTAL Qualifier?

LinEst_M(TOTAL count(distinct valueNumber), after(count(distinct valueNumber)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful