topic Sets Variable Expression issue in QlikView

Sets Variable Expression issue

shyamcharan — Mon, 23 Feb 2015 05:43:05 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.

cn_sa_dev — Mon, 23 Feb 2015 16:40:52 GMT

Hi Shyam,

Your model seems to be corrupted, can you upload it again?

Regards,

Chris

shyamcharan — Mon, 23 Feb 2015 21:54:47 GMT

Hi Chris,

Thanks for coming back on this issue.

I have reattached the QVW. Please let me know if you still have the issue.

However, the issue is resolved when I replace hyphen with the minus sign.

I had hyphen instead of minus before int he sets definition.

Thanks heaps.

Regards,

Shyam.