topic Re: Set Analysis and Selection form list box in QlikView

Set Analysis and Selection form list box

shane_spencer — Fri, 25 May 2018 11:05:08 GMT

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?

Re: Set Analysis and Selection form list box

Chanty4u — Fri, 25 May 2018 11:08:43 GMT

not clear what it is text box expression?

Re: Set Analysis and Selection form list box

sunny_talwar — Fri, 25 May 2018 11:29:58 GMT

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'

Re: Set Analysis and Selection form list box

shane_spencer — Fri, 25 May 2018 12:18:45 GMT

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