topic Re: YoY Growth % Calculation in QlikView

YoY Growth % Calculation

vikasmahajan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: YoY Growth % Calculation

sunny_talwar — Wed, 24 Jan 2018 12:50:32 GMT

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%')

Re: YoY Growth % Calculation

vikasmahajan — Wed, 24 Jan 2018 13:28:46 GMT

works perfect !!

thanks

Vikas

Re: YoY Growth % Calculation

vikasmahajan — Wed, 24 Jan 2018 13:34:11 GMT

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

Re: YoY Growth % Calculation

sunny_talwar — Wed, 24 Jan 2018 14:35:57 GMT

Ignore selection in FinancialYear field for your color expression aswell