Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Creator
Creator

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.

Highlighted
Creator
Creator

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