How to keep data inside pivot for only 1 item while several has chosen

Wed, 29 Apr 2015 06:58:30 GMT

Hi everyone,

I've got some problem with several pivots and objects.
What i want to do is choose any variation of 2 items from listbox and get a pivot for each of them only without any other data, so for certain item i need to determine directly which pivot should contain it (6-7 tables max). Because now i get both selected items in a row inside a pivot.

I want to do it like this:

Listbox1
ob1 <-selected
ob2 <-selected
ob3
ob4

Pivot1 Pivot2
Dim1 ob1 Dim1 ob2

Dim2 ob1.staff Dim2 ob2.staff

Dim3 ... Dim3 ...

The main question is what tipe of solution would it be: script editing or calculated dimension or expression or smth else?

Re: How to keep data inside pivot for only 1 item while several has chosen

Gysbert_Wassenaar — Fri, 01 May 2015 08:57:39 GMT

If you make sure to select only two values you can probably use set analysis expressions. Suppose you have sum(Sales) as chart expression. You could modify that to these:

sum({<Dim1={"$(=MinString(Dim1))"}>}Sales)

sum({<Dim1={"$(=MaxString(Dim1))"}>}Sales)

But perhaps you should consider using alternate states and use two listboxes, one for each alternate state. You can find more information about that in this blog post: Why Comparative Analysis

topic How to keep data inside pivot for only 1 item while several has chosen in QlikView

How to keep data inside pivot for only 1 item while several has chosen

Re: How to keep data inside pivot for only 1 item while several has chosen