Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
question:
I followed instructions on p. 389 yet I cannot get any results in the Straight Table I created (see results.png attached)
May I ask you where I have gone wrong?
I have also attached dimensions.png and expressions.png
Moreover, I do not understand why a dimensions def. like Sum({$<$(vSetPreviousMonth(0))>} [# Departures Performed])
has [# Departures Performed]) underlined as I copied and pasted Definitions from a book.
thanks!
If it is underlining then it suggests that the column doesn't exist, but it isn't always accurate.
Can you share the application you have, its a long time since I looked at anything like this.
If it is underlining then it suggests that the column doesn't exist, but it isn't always accurate.
Can you share the application you have, its a long time since I looked at anything like this.
Adam,
thanks for your help. the app is like a 58 Mb file. i do not think I would be allowed to attach it in this forum.
Best regards,
Joshua.
ok
I have found how to resolve.
IN variables Overview (accessed with Ctrl+Alt+V)
I made sure to edit all Var. defs to contain all the formulas on the same line
Thus, for example, I changed this def:
QuarterID = {$(=Max(QuarterID) – 1)},
Year = ,
Quarter = ,
Month = ,
Period =
to:
QuarterID = {$(=Max(QuarterID) – 1)}, Year = ,Quarter = ,Month = ,Period =
and now I have everything correctly showing in the Prev . Month Straight table
go and figure this QlikView interpreter!
thanks for your help