topic Re: Set analysis syntax for multi year in QlikView

Set analysis syntax for multi year

oxiofrt — Mon, 12 May 2014 14:30:44 GMT

Hi,

I have created a chart (simplified in the example herejoined) which display a mesure for 5 years (the selected one and the 4 years before).

In this chart I would like to display the value of the year (it works...) and the value of the year before (and it doesn't works).

I am not sure it is possible... Could you please help ?

Thanks a lot !

Re: Set analysis syntax for multi year

Anonymous — Mon, 12 May 2014 14:46:53 GMT

for years use expression in set analysis like

current year

sum( {$<EXERCICE = {$(#=max(EXERCICE))}>} Sales )

previous year

sum( {$<EXERCICE = {$(#=max(EXERCICE)-1)}>} Sales )

hope it helps

Sri1

Re: Set analysis syntax for multi year

maxgro — Mon, 12 May 2014 14:53:23 GMT

maybe

= Sum ( {$ <EXERCICE={">=$(=max(EXERCICE)-5)<=$(=max(EXERCICE)-0)"},ID_CHAPITRE= {"74"}, ID_SECTION={"F"}, ID_SENS={"R"} > } MT_TTC_MANDAT_TITRE)

Re: Set analysis syntax for multi year

sudeepkm — Mon, 12 May 2014 15:01:50 GMT

as per the comment mentioned in the text object, do you want to display the value of prev year in the next yr that means do you want to show the value of 2011 (56 805) in the year 2012. As per your data the chart is currently showing correct values. I did a simple selection and found it. Please confirm.

Re: Set analysis syntax for multi year

oxiofrt — Mon, 12 May 2014 15:24:21 GMT

Thanks a lot for your answer !

I would like to have both value in the table : N and N-1, just as in the table hereafter :

Re: Set analysis syntax for multi year

oxiofrt — Mon, 12 May 2014 15:30:18 GMT

Thanks a lot for your answer.

It may not work as I would like to have the value for each year, and not only for the year before the current year

(in the example herafter, with your formula, I retrieve only one value. I don't want to create 5 expression but only one)

The expected result :

Thank you