Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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