Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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