topic Re: complex set analysis in QlikView

complex set analysis

Sun, 01 Feb 2015 11:01:32 GMT

Dear all,

I would like to do the following. I have machines that follow certain maintenance cycles:

That means I have 3 machines that have cycle 2 and 3, and 4 machines that have only cycle 3.

If I do =count(DISTINCT Maschine) with Dimension Cycle I something like this:

But I would like to have that the machines are counted, that have cycle 2 and 3 and machines that have only cycle 3.

So my table should look like:

How can I achive this?

Thanks for any help...

Peter (desperate)

maxgro — Sun, 01 Feb 2015 11:32:08 GMT

if I understand

Sun, 01 Feb 2015 11:35:36 GMT

Thanks, Massimo.

I only have the personal edition, so I can't open the example.

But I found out. I have to use the aggr() function:

=aggr(min(Cycle),Machine) as new Dimension... worked.

Peter

maxgro — Sun, 01 Feb 2015 11:44:27 GMT

script

LOAD Machine,

Cycle

FROM

(html, codepage is 1252, embedded labels, table is @1);

left join (a)

load

Machine,

Concat(DISTINCT Cycle, '-', Cycle) as CycleGroup

Resident a

Group by Machine

;

chart is CycleGroup and count distinct