Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Straight Table Issue

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

MVP
MVP

Re: Straight Table Issue

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.

prabhu0505
Valued Contributor

Re: Straight Table Issue

Not applicable

Re: Straight Table Issue

Hi Sunny,

These were the images in sequence

  

Thanks

Not applicable

Re: Straight Table Issue

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. 

MVP
MVP

Re: Straight Table Issue

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.