Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis does not correctly work in Qlik sense

In my data, there is one column myField,

I use myField for Qlik sense Filter pane.

I put the following in Qlik sense Text&image object to dynamically show the selected value (myPen, myBook, myPaper) from myField, such as the following:

'Count of my selected myPen : ' & Count( {$<[myField]={'myPen'}>} [myField] ) & chr(13)

& 'Count of my selected myBook : ' & Count( {$<[myField]={'myBook'}>} [myField] ) & chr(13)

& 'Count of my selected myPaper : ' & Count( {$<[myField]={'myPaper'}>} [myField] ) & chr(13)

However, the above expression always show the total number of each category (myPen, myBook, myPaper), the number will NOT dynamically change when I select different value (myPen, myBook, myPaper) from myField.

Could you please give any suggestion?

1 Solution

Accepted Solutions
sunny_talwar

Try this out:

'Count of my selected myPen : ' & Count({$<[myField] *= {'myPen'}>} [myField] ) & chr(13)

& 'Count of my selected myBook : ' & Count( {$<[myField] *= {'myBook'}>} [myField] ) & chr(13)

& 'Count of my selected myPaper : ' & Count( {$<[myField] *= {'myPaper'}>} [myField] ) & chr(13)

View solution in original post

2 Replies
sunny_talwar

Try this out:

'Count of my selected myPen : ' & Count({$<[myField] *= {'myPen'}>} [myField] ) & chr(13)

& 'Count of my selected myBook : ' & Count( {$<[myField] *= {'myBook'}>} [myField] ) & chr(13)

& 'Count of my selected myPaper : ' & Count( {$<[myField] *= {'myPaper'}>} [myField] ) & chr(13)

Anonymous
Not applicable
Author

Works.Thanks so much for your help!