topic Re: Set Variable expression issue in QlikView

Set Variable expression issue

shyamcharan — Mon, 23 Feb 2015 05:49:13 GMT

Hi Experts,

I am in a stage of learning the SETS and encountered an issue while working on an example dashboard.

Attached is a QVW document where I have a Straight Table and I do not get any results in this table.

I have created variable vSetPreviousNMonth and used this variable in the sets of the chart expressions.

The definition of this variable is :

PeriodID = {$(=Max(PeriodID) – $1)},

Year = ,

Quarter = ,

Month = ,

Period =

The expressions are :

Sum({$<$(vSetPreviousNMonth(0))>} [# Departures Performed])

Sum({$<$(vSetPreviousNMonth(1))>} [# Departures Performed])

Sum({$<$(vSetPreviousNMonth(2))>} [# Departures Performed])

Can anyone please tell me what mistake I am doing.

Thanks heaps in advance.

Regards,

Shyam.

Anonymous — Mon, 23 Feb 2015 06:39:33 GMT

Hi Shyamcharan,

In the following expression change the hyphen(-) symbol to minus symbol as the Qv calculation does not accept the above.

PeriodID = {$(=Max(PeriodID) – $1)}

Thanks,

Vignesh

awhitfield — Tue, 24 Feb 2015 09:21:57 GMT

looks like you are using 'Qlikview11 for Developers', Vignesh is correct:

PeriodID = {$(=Max(PeriodID) - $1)},
Year = ,
Quarter = ,
Period = ,
Month =

You can always check it against the solution file supplied for the book

shyamcharan — Tue, 24 Feb 2015 09:57:54 GMT

Thanks Vignesh.

Thats solved my issue.