Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Set Analysis and Selection form list box

I've got an issue with Set Analysis. I've got a formula in a text box to count Status and Manual Status, but I've also got these as selections in list boxes. The issue is if I select Confirmed from Manual Status for example the figures circled in the text box should show 0 but are showing the total count. Is there an easy way to fix this?

set anal.PNG

1 Solution

Accepted Solutions
sunny_talwar

Try this and also read about the use of * here Implicit Set Operators

=Count( {< Status *= {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status *= {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

or this

=Count( {< Status = {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status = {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

Capture.PNG

View solution in original post

3 Replies
Chanty4u
MVP
MVP

not clear   what it is text box expression?

sunny_talwar

Try this and also read about the use of * here Implicit Set Operators

=Count( {< Status *= {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status *= {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

or this

=Count( {< Status = {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status = {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

Capture.PNG

shane_spencer
Specialist
Specialist
Author

Thanks Sunny! And thanks again for the link, I've only used the Implicit Exclusion before.