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 Shyam,
Your model seems to be corrupted, can you upload it again?
Regards,
Chris
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.