Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
happyjoshua777
Creator
Creator

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!

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

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.

View solution in original post

3 Replies
adamdavi3s
Master
Master

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
Creator
Creator
Author

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
Creator
Creator
Author

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