Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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%')
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%')
works perfect !!
thanks
Vikas
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
Ignore selection in FinancialYear field for your color expression aswell