Set Analysis multiple rows

cbaqir — Wed, 19 Aug 2015 20:03:51 GMT

I read this and now I think I need an alternative:

Limitation: take care, a set analysis is calculated once per chart (or table). NOT once per row. If you

want a different result in your set analysis according to the row being calculated and displayed, it will NOT

work. Change the way to compute your data (model, if statement) but forget the set analysis.

I have a straight table that shows counts by different statuses using set analysis but I'm seeing values that don't make sense and I think it's because I am using set analysis for each expression.

For example, the Open Count expression is: =count(DISTINCT{$<REQ_STATUS={'Open'}>} REQUEST_ID) and the On Hold expression is: count(DISTINCT{$<REQ_STATUS={'On Hold'}>} REQUEST_ID)

I have of a list box for REQ_STATUS that if a user selects 'Open', I would expect the 'On Hold' count to be 0, but this is not the case.

Would something like the following be the correct expression for On Hold Count instead? count(if(Match(REQ_STATUS,'On Hold')>0,1,0))

Thanks,

Cassandra

Re: Set Analysis multiple rows

Nicole-Smith — Wed, 19 Aug 2015 20:15:53 GMT

Try this:

count({$*<REQ_STATUS={'On Hold'}>} DISTINCT REQUEST_ID)

This should only do the count where the current selections ($) and (*) the set analysis (status is 'On Hold') are true.

topic Re: Set Analysis multiple rows in QlikView

Set Analysis multiple rows

Re: Set Analysis multiple rows