Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi
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
Thanks Vignesh.
Thats solved my issue.