Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

srinivasa1
Contributor

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.

Tags (1)
4 Replies
udit_kumar_sana
Contributor II

Re: Sales difference for years selected range of years and month

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
Contributor

Re: Sales difference for years selected range of years and month

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
Contributor II

Re: Sales difference for years selected range of years and month

Hi,

Please find here the attached file.

Regards,

Udit

srinivasa1
Contributor

Re: Sales difference for years selected range of years and month

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

Community Browser