If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I wanted to show Growth % for Sales in the pivot table having dimensions shown in below snippet. I'm using the following expression to calculate the growth%.
It works fine if I have only Fiscal Quarter and Month as the row dimensions. When I add the fiscal year in rows dimensions, I get the wrong output displayed in below snippet:
Thanks in advance..!!!
I tried using above function, it fails because,
YTD - It calculates, growth% with this year with the previous whole year instead of calculating this year with previous year till date.
QTD and MTD - It calculates, growth% with current Quarter/Month with Previous Quarter/Month but the requirement is to calculate using current year current Month/Quarter with previous year same Quarter/Month.
Please find the attached app. !
In the attached app, I tried to calculate growth% for the fiscal quarter and month it is working fine. But I swap the fiscal year as the first dimension in the pivot table calculation doesn't work correctly.
Thanks in advance..!! and kindly excuse my delayed reply.
@mohan_1105 did you ever find a solution to this issue?
I am facing a similar item where I have only month-end dates, and can pull up each value individually but they do not work when subtracted from one another. Your solution has shown most promise, but had to add in Above() to one sum. However it isn't the full solution.