Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count of specific values

Hello All,

I need to get the count of a specific field to be changed based on variable but it'not working

below is an example using static value

Count ({1 <space_name={'XXXXX'}>} discussion_create_date)


i need to remove the 'XXXX' and put variable that may contain  1 2 or more values


any suggestion ??

4 Replies
Anonymous
Not applicable
Author

try this

Count ({1 <space_name={'$(=yourvariable)'}>} discussion_create_date)

Anonymous
Not applicable
Author

Thank you

i tried but not working

Anonymous
Not applicable
Author

Hi, Maybe  this help you.

This exclude 'XXXX'

Count ({1 <space_name-={'XXXXX'}>} discussion_create_date)

This is less 'XXXX'

Count ({1 <space_name=-{'XXXXX'}>} discussion_create_date)

Regards.

Anonymous
Not applicable
Author

Thank you

but am adding this in chart Dimension not in the script