Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

happyjoshua777
Contributor

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

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!

Tags (1)
1 Solution

Accepted Solutions
adamdavi3s
Honored Contributor

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

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.

3 Replies
adamdavi3s
Honored Contributor

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

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
Contributor

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

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
Contributor

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

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