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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Growth Calculation Expression

The below expression considered for growth calculation in the report

(sum(sale_amount)/Before(sum({<Yr>}sale_amount))-1)

And

(sum(sale_amount)/Before(sum({<Yr>}sale_amount))-1)*avg(1)

  1. Can some one tell me why to consider *avg(1)

         Where avg(1) returns 1

    2. if we give in set expression as {<Yr=>} instead  {<Yr>} both does the same ??? to not get filtered year selection

* My Intention behind this is to understand this expression clearly

-Hope someone can help me with this

10 Replies
sunny_talwar

Super