Discussion Board for collaboration on QlikView Scripting.
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...
if I understand
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.
(html, codepage is 1252, embedded labels, table is @1);
left join (a)
Concat(DISTINCT Cycle, '-', Cycle) as CycleGroup
Group by Machine
chart is CycleGroup and count distinct