Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Sales difference for years selected range of years and month

Hi,

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.

4 Replies
udit_kumar_sana
Creator II
Creator II

Hi,

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.

Regards,

Udit

srinivasa1
Creator II
Creator II
Author

Hi Sanadhya,

Thanks for ur suggestion.but i dint got properly,will you pls add in my sample app and attached

Thanks in advance.

udit_kumar_sana
Creator II
Creator II

Hi,

Please find here the attached file.

Regards,

Udit

srinivasa1
Creator II
Creator II
Author

thanks.let me check.i will get back 2 you.