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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

values getting changed

Hi All,

I have 2 expression  in the attached.

PFA

My question is when I select Months my 2 expression "Growth" values changed.

Thanks

12 Replies
tresesco
MVP
MVP

Try redefiing the variable like:

vFY =Year(addyears(max( {<MonthName>}Date),-4))

You might have to include other time dimensions too to bypass their selection effect.

prma7799
Master III
Master III
Author

Hi Manish,

In expression there is no need to FiscalYear={">$(vFY)"} (vFY).

I want when i select month then growth figure is come properly

Growth formula is  ((CYMonth - LYMonth) / LYMonth )*100

Thanks

prma7799
Master III
Master III
Author

Hi All / tresesco, jagan , sunindia , swuehl , maxgro,

Any solution on this ?

Thanks