topic Re: Set Analisys Issue in QlikView

Set Analisys Issue

Thu, 26 Dec 2013 05:44:14 GMT

Hi All,

I am new in qlikview and facing the issue in my set,

my question is can we get the last year values dynamic based on current year selection or based on other parameter selection.

thanks in advance

Alok Kumar

Re: Set Analisys Issue

Thu, 26 Dec 2013 05:57:21 GMT

try this

sum( {$<Year = {$(=Only(Year)-1)}>} Sales )

returns the sales for the previous year in relation to the current

selection. Here, a dollar-sign expansion is used to calculate

previous year.

******************************************************

try this

sum(({<Year={$(=max(Year))},

Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)

Returns this year’s sales for customers who had sales last year.

Re: Set Analisys Issue

senpradip007 — Thu, 26 Dec 2013 06:00:00 GMT

Hi alok,

try this:

Sum({<Year = {'$(=Max(Year) - 1)'} >} YourField)

Re: Set Analisys Issue

Thu, 26 Dec 2013 06:01:51 GMT

hi try this

sum({<Date={$(prevyear)}>}sales)

Variable:

prevyear=max(year(Date(Datefield,'DD/MM/YYYY'))-1)

Re: Set Analisys Issue

jagan — Thu, 26 Dec 2013 06:05:17 GMT

Hi,

Try like this

Sum({<MonthDimensionName=, QuarterDimensionName=, YearDimensionName = {'$(=Max(YearDimensionName ) - 1)'} >} MeasureName)

In the above expressions replace MonthDimensionName, QuarterDimensionName, YearDimensionName with your date fields and if there are anything other that this in your sheet just include those also. Replace MeasureName with your measure like Sales, Revenue etc.

MonthDimensionName=, QuarterDimensionName=, YearDimensionName= will ignore the selections in this dimensions and always show the full year values even if this values are selected.

Regards,

Jagan.

Re: Set Analisys Issue

Thu, 26 Dec 2013 07:04:35 GMT

Hi All.

thanks for your valuable help,

but above all the methods are not working.

even i have tried with same expression of standard Set.

but did not get success.

I am attaching the QVW for your reference.

also note that there are few more parameters are exist into same table based on it we need to give the o/p

Re: Set Analisys Issue

jagan — Thu, 26 Dec 2013 07:14:15 GMT

Hi,

What value you are expecting for 2013-14?

Regards,

Jagan.

Re: Set Analisys Issue

Thu, 26 Dec 2013 07:21:47 GMT

HI,

I want last year values based on current year selection, and i have also few more parameters which needs to be added into the t1 table.

Re: Set Analisys Issue

Thu, 26 Dec 2013 09:54:21 GMT

Hi All,

Has any one has got solution?

Re: Re: Set Analisys Issue

Gysbert_Wassenaar — Thu, 26 Dec 2013 10:17:00 GMT

You need to override the selection in FISCALYEAR for the expressions for the previous year. See attached qvw.

Re: Set Analisys Issue

Fri, 27 Dec 2013 05:01:49 GMT

Thanks

Gysbert that is the perfect solution.