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
Not applicable

Straight Table Issue

Hi Everyone,

Recently I came across something strange(Not sure, if it's new or something I never noticed before ) while using straight table in Qlikview.

I have added an expression in the straight table which calculates the variance between the current row and the row above it.

(sum([Units] ) / above (sum([Units] ) )  )-1

On selection of a particular time period i.e Year/ Quarter/ Month/ Week, it works perfectly fine, but with multiple dimensions selected, it fails to work.

Also if I change the order of few dimensions, it gives blank values. See below:

                   

Any possible reasons for this? All I can think of is, with multiple dimensions selected, may be Qlikview baffles which field to reference??

Thanks,

Swati

6 Replies
Highlighted

Your image is not showing up. Is there any way you can share a sample app?

Highlighted
MVP
MVP

If you are using multiple dimensions, be aware that above won't return values when it needs to cross a column segment ( a change in dimensional value in any column other than the last dimension). You can use the TOTAL qualifier if you want to disregard the column segments.

Highlighted
Specialist
Specialist

Highlighted
Not applicable

Hi Sunny,

These were the images in sequence

  

Thanks

Highlighted
Not applicable

Thanks all!! Just needed to understand the behavior of the chart. Using peek() in load function or aggr() and total qualifier() would get me the desired result. 

Highlighted
MVP
MVP

Seems to me that your images are stored on an external server (MS online) and are not accessible for others (at least without access to that server). Would be better to upload images to the QV forum.