topic Re: Count of specific values in QlikView

Count of specific values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ??

Anonymous — Tue, 16 Aug 2016 14:43:52 GMT

try this

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

Anonymous — Tue, 16 Aug 2016 14:50:32 GMT

Thank you Rudolf Linder

i tried but not working

Anonymous — Tue, 16 Aug 2016 14:52:35 GMT

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 — Tue, 16 Aug 2016 14:55:33 GMT

Thank you maverjannet

but am adding this in chart Dimension not in the script