topic Set Analysis Doubt in QlikView

Set Analysis Doubt

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We have a chart displaying time duration for a drilldown(Customer,division etc) over a no of steps. Now when a particular division is selected and a step is selected, we want to see the duration for all other divisions for the particular step. Can this be done using Set Analysis.

I tried Avg({$<step={'*'}>}{1-$}duration). It shows the result for all other divisions but it remains the same for any step i choose. Anyone having any ideas. Thank you.

Re: Set Analysis Doubt

johnw — Wed, 25 May 2011 22:51:21 GMT

Maybe this?

avg({<division=E()>} duration)

Re: Set Analysis Doubt

Thu, 26 May 2011 16:58:03 GMT

Thanks. But it is still the same. Maybe making two selections is affecting the set Analysis

Re: Set Analysis Doubt

johnw — Thu, 26 May 2011 17:43:38 GMT

avg({<Division=E()>} total Duration)

That seems to work in the attached example. If that's not what you meant, I'll need further explanation, preferably in the form of modifying the example to demonstrate both the problem you're having and the result you expect.

Re: Set Analysis Doubt

Thu, 26 May 2011 18:10:35 GMT

In this example when i choose B, it shows only B values. What We want to see is when B is selected, we want to see data for everything except B(In this case A). So i tried using {1-$} before the total duration, but it doesn't work. The value remains same for all the steps.

Re: Set Analysis Doubt

johnw — Thu, 26 May 2011 19:05:26 GMT

See the attached example. I've added Division C.

Now, if you select division B, step 1, the FIRST chart (which was the first expression I gave you), shows instead divisions A and C, and the average duration for each for step 1. That's what I initially thought you wanted.

But you didn't like that answer, so I guessed that maybe you instead wanted an overall average of A and C's step 1 on the same line as division B. That's the second expression, shown in the second chart.

If you don't want to see A and C's data separately, and you don't want to see it with B, then where DO you want to see it?

Or... you mention the value remaining the same for all the steps. In your initial explanation, you said you were selecting a specific step ("and a step is selected"). Is that NOT the case now? So you want to NOT select a step, JUST a division, and see the average for A and C associated with the step on the line in the chart? In that case, this seems to work:

aggr(nodistinct avg({<Division=E()>} Duration),Step)

Right or wrong, I'm done playing guessing games. I won't be replying to this thread again.

Re: Set Analysis Doubt

Thu, 26 May 2011 20:07:05 GMT

Well. There seems to be some misunderstanding. Anyway Thanks for the reply.

Re: Set Analysis Doubt

Thu, 26 May 2011 21:01:03 GMT

It seems to be working now. What would we do if we need to include a cyclic group(division is a part of cyclic group)?