topic Re: Set analysis in QlikView

Set analysis

Mon, 29 Oct 2012 15:33:40 GMT

Hi,

I have ID, Date and Flag in a table.

Now I have to count the IDs which have only Y status in the week selected. In this example, for w33, only ID-2 has to be counted.

I have tried to acheive this with set analysis count({<FLAG={'Y'},Row_No={"=max(Row_No)"}>}distinct ID). But it didn't work.

Any idea on this?

swuehl — Mon, 29 Oct 2012 15:41:38 GMT

Try

= -sum( aggr( FirstSortedValue(Flag, -Row_No) = 'Y', ID))

assuming the 'N' status flag will appear only on the highest Row_No per ID.

whiteline — Mon, 29 Oct 2012 19:39:33 GMT

You can try this one (use different quotes carefully as stated below):

=count({<FLAG={'Y'}, Row_No={"=max({<FLAG={'Y'}>} Row_No)"}>} distinct ID)