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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
10 Replies
sunny_talwar

Super