YoY Growth % Calculation

[vikasmahajan]

Hi all,

I am using following formula to calculate the growth % year over Year  By default  Financial Year is selected in calendar.

Dimension :  Year

                     Company

Sales Value : num(Sum( Y2Sale) / Sum(TOTAL <Year> Y2Sale),'##.#0%')

I wanted to ignore financial Year in expression how to ignore

Thanks

Vikas

[sunny_talwar · Accepted solution]

I did give you a solution in your previous thread Vikas, did you ever try that?

Re: YoY Market Share Calculation in qlik sense

num(Sum({<FinancialYear>}Y2Sale) / Sum({<FinancialYear>} TOTAL <Year> Y2Sale),'##.#0%')

[vikasmahajan]

works perfect  !!

thanks

Vikas

[vikasmahajan]

Sunny I have used  Variable for displaying diff companies with RGB and in expression colour using this displaying company colour could me tell me only  2018 is seen in colour where as other's not coloured what may be issue?

Any guess ?

Vikas 

[sunny_talwar]

Ignore selection in FinancialYear field for your color expression aswell