topic Re: Prev Month Straight Table p. 389 - Qlikview for developers Ch. 11 in QlikView

Prev Month Straight Table p. 389 - Qlikview for developers Ch. 11

happyjoshua777 — Wed, 25 Nov 2020 16:16:04 GMT

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!

adamdavi3s — Wed, 01 Mar 2017 10:53:07 GMT

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.

happyjoshua777 — Sun, 05 Mar 2017 01:43:23 GMT

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.

happyjoshua777 — Sun, 05 Mar 2017 02:12:08 GMT

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