topic Re. :Problem with aggregate/set analysis in QlikView

Problem with aggregate/set analysis

Fri, 21 May 2010 14:52:51 GMT

Hi,

I'm trying to find a way to create a table where I can only see the customers with the same adress code and with demand=0.

So, I have a table like this one:

And want to get one like this, for all customers with repeated adress code and demand=0:

How can I do it? Should i use a pivot table? (I just can't manage it to work correctly...)

martin59 — Fri, 21 May 2010 15:06:11 GMT

Hello,

Look at the attachement and screenshots to understand.

Hope that helps you.

Fri, 21 May 2010 15:44:35 GMT

Hello,

Thank you, but it doesn't seem to work (I only qview personal edition so I have some problems opening other users files).

The problem is, and I might not have explained it well enough, when I have customers where the code isn't repeated, so those will appear anyway.

To get to:

So: I only want to get customers with demand zero whose code appears more than one time (example, customer 7 should not appear).

martin59 — Fri, 21 May 2010 15:56:07 GMT

So you can try this :

jedgson — Fri, 21 May 2010 16:13:58 GMT

You could also create a new field (count) in the script to count the occurances of code

You could then use something like

if(count >1 and demand = 0, 1, 0)

Mon, 24 May 2010 10:34:04 GMT

Thank you Martin! That's it.