Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Set Analysis multiple rows

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

1 Solution

Accepted Solutions
Highlighted

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.

View solution in original post

1 Reply
Highlighted

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.

View solution in original post