Discussion Board for collaboration on QlikView Layout & Visualizations.
Can any one pls guide me how I can do Sales difference for selected range of years?
Also if I select year 2011 from slider my pivot table label show as (2013-2011) instead of (2013-2012)
How I can avoid that if its selected year is 2011.it should look like (2013-2012) and (2012-2011)
Pls suggest if any other way to achieve this analysis. Attached sample app
Pls suggest Thanks in advance.
You can do this by creting a new filed at script level as below:
YearName(Year,0,4) as FIN_YEAR
This will give all financial year from your filed year.
Then you can compare month on month basis for every financial year.
Thanks for ur suggestion.but i dint got properly,will you pls add in my sample app and attached
Thanks in advance.
Please find here the attached file.
thanks.let me check.i will get back 2 you.