topic Re: Straight Table Issue in QlikView

Straight Table Issue

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Straight Table Issue

sunny_talwar — Mon, 02 Nov 2015 18:09:42 GMT

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

Re: Straight Table Issue

swuehl — Mon, 02 Nov 2015 18:12:16 GMT

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.

Re: Straight Table Issue

prabhu0505 — Mon, 02 Nov 2015 18:22:51 GMT

The Above Function

Re: Straight Table Issue

Tue, 03 Nov 2015 10:18:22 GMT

Hi Sunny,

These were the images in sequence

Thanks

Re: Straight Table Issue

Tue, 03 Nov 2015 10:21:05 GMT

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.

Re: Straight Table Issue

swuehl — Tue, 03 Nov 2015 11:00:30 GMT

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.