Solved: set analysis expression - Qlik Community

Anonymous · ‎2017-05-26

hi there,

ı have a table like that :

ı want to filter ID s like that :

Display ONLY the ID that includes BOTH category = "car" and "bus"

( here the answer is ID='3969385' that is the one includes both, there are other ID that only inclues one of them that is useless for us)

Anyone can help? thank you.

sunny_talwar · ‎2017-05-26

lol sure...

Sum({<ID = {"=Count(DISTINCT {<category = {'car', 'bus'}>} category) = 2"}>} money)

sunny_talwar · ‎2017-05-26

May be like this

Sum({<ID = {"=Count(DISTINCT {<category = {'car', 'bus'}>} category) = 2"}>} sum)

jtay · ‎2017-05-26

maybe this one: Count({<match(category,'car','bus')>}ID)

Anonymous · ‎2017-05-26

it says , error in set modifier

Anonymous · ‎2017-05-26

bad field names : sum

sunny_talwar · ‎2017-05-26

You provided that field in your data my friend

I guess it would be helpful if you don't provide bad field names: sum

sunny_talwar · ‎2017-05-26

The set analysis is working... have a look

Anonymous · ‎2017-05-26

my bad , you are right. ı changed it to "money"

sunny_talwar · ‎2017-05-26

edit what? what are you trying to edit?

Anonymous · ‎2017-05-26

ok ı fixed it . edited.

can you write the formule accdng to that please

set analysis expression