Comparing two years sales without set analysis

[#1]

hi,

can any body tell me how to show current year and previous years charts with out set analysis.

regards

Mahesh T

[maxgro]

sum(if(Year=2014, Sales))

sum(if(Year=year(Today())-1, Sales))

[stigchel]

In script you create a calendar with the desired time ranges in a field to include as a dimension in your charts. Here you can find how to do that:

Qlikview Notes: Easy Period Analysis using Qlikview Components

[sujeetsingh]

mahesh why dont you want set analysis?

Do you have any technical reason or advantage of not using the set modifier.

[#5]

Hi sujeet,

it is asked in interview generally i do with set analysis.But he particularly mentioned about that.

regards

Mahesh t

[sujeetsingh]

ok that is to test the tricks .

Ok you can use the is satement as one suggested and also use the document function to accomplish that .

[#7]

fine Sujjeth .can you please give me solution to suppose for previous year we apply modifier '1' for all selections and '$' for current selections.can we achieve by any other option can you please give me functions too for expressions.

regards

Mahesh T

[#8 · Accepted solution]

You can use Alternate States. It means that some selections will be done on Alternate1, some on Alternate2. So one will get Year Ago, one will get this year.

Each Chart can be linked to a specific Alternate State.

You create the first AS by clicking on Document Properties / general Tab / Alternate States. After that, the AS will be available for ListBox, Chart ...

Fabrice

[#9]

fine answer can u elaborate with some example naming in alternate states etc.

[#10]

Sorry, I do not understand what you mean.

Alternate States are an "out-of-the-box" possibility of QlikView.

Look for some docs about it: there are plenty I am sure

Fabrice