topic Re: Segmenting Pivot in QlikView

Segmenting Pivot

Tue, 28 Aug 2012 13:13:34 GMT

I have done a Pivot over our products, but I only wanted the chart to show 4 different product groups - how do I solve this?

Re: Segmenting Pivot

Tue, 28 Aug 2012 13:40:27 GMT

You can do it with set analysis if you know which groups you want to see, or you can restrict which are displayed if you wanted to see the top four categories, for example. The attached qvw shows a couple different ways.

Re: Segmenting Pivot

Tue, 28 Aug 2012 14:51:13 GMT

Sorry I'm on a personal lincense, so i can't open your files

Re: Segmenting Pivot

whiteline — Tue, 28 Aug 2012 14:56:39 GMT

He means instead of simple expression, for example, Sum(Revenue) you should use something like

Sum({$<product_master_name={"Guld Profil", "Spigos"}>} Revenue)

This means we've selected "Guld Profil" and "Spigos" from product_master_name before calculating the Sum(Revenue).

Try to search in a help index the words "Set Analysis".

Re: Segmenting Pivot

Tue, 28 Aug 2012 15:01:57 GMT

Oh no problem. Using the following example:

So for set analysis, your expressions would look something like this:

Which would give you a result like this:

Or you can show, say, only the top two values by selecting 'Restrict which values are displayed' and selecting 'Show Only Largest X Values'. Deselect 'Show Others'.

This would give you: