topic Re: Suppress lines on a pivot table in QlikView

Suppress lines on a pivot table

ranibosch — Sat, 16 Nov 2024 19:38:07 GMT

Good day,

i would like to know if there is a way to suppress results on a pivot table.

i have a pivot table where i do not want it to show the result where sales for the last x2 months have been zero.

see screenshot of below:

pivot table

Re: Suppress lines on a pivot table

Gysbert_Wassenaar — Wed, 20 Nov 2019 09:27:12 GMT

You'll have to do that with set analysis expressions. Every chart expression in your pivot table needs to be modified to include a filter that selects only those lines that meet your conditions. Perhaps you can post a small qlikview document that we can modify this way.

Re: Suppress lines on a pivot table

ranibosch — Wed, 20 Nov 2019 09:58:12 GMT

Thank you for feedback Gysbert.

please find sample file attached.

Re: Suppress lines on a pivot table

ranibosch — Wed, 20 Nov 2019 13:30:26 GMT

Basically my expression in the pivot table looks like this:

Sum ([Shop Sales Past 2 months])/2*-1

How do I insert a set analysis into this expression to only show results greater than zero in the object?

Re: Suppress lines on a pivot table

ranibosch — Wed, 20 Nov 2019 13:47:20 GMT

I was thinking something like this:

Sum (

//insert set analysis here

{ < {(Sum ([Shop Sales Past 2 months])/2*-1 / [Case weight]) > '0' > }

//end of set analysis

[Shop Stock Level])
/
[Case weight]

This does not work at all though..

Re: Suppress lines on a pivot table

Brett_Bleess — Thu, 05 Dec 2019 16:51:41 GMT

Ranibosch, best I have for you is the following Design Blog post on Set Analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are some related links at the bottom of that post. Below is the base Design Blog URL as well, you can use it to do some further searching if you like.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Cheers,
Brett