Straight Table Issue

[#1]

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

[sunny_talwar]

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

[swuehl]

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]

The Above Function

[#5]

Hi Sunny,

These were the images in sequence

  

Thanks

[#6]

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. 

[swuehl]

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.