topic Re: set analysis expression in QlikView

set analysis expression

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

hi there,

ı have a table like that :

ID	YEAR_MONTH	category	money
3969385	201502	car	1.206
3969385	201506	bus	2.455
28289815	201502	x	610
22291674	201506	car	1.224
23481102	201506	t	563
10126853	201508	bus	445
360150	201503	r	1.231
1631437	201511	w	523

ı 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.

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:04:23 GMT

May be like this

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

Re: set analysis expression

jtay — Fri, 26 May 2017 17:06:56 GMT

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

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:12:41 GMT

it says , error in set modifier

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:14:57 GMT

bad field names : sum

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:16:19 GMT

You provided that field in your data my friend

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

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:17:05 GMT

The set analysis is working... have a look

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:19:25 GMT

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

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:20:55 GMT

edit what? what are you trying to edit?

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:22:31 GMT

ok ı fixed it . edited.

can you write the formule accdng to that please

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:23:57 GMT

lol sure...

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

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:30:19 GMT

thank you my friend, that worked like a charm.

but here the case I want is to FILTER them also. I want to show only the ID s that has this condition on table.

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:32:05 GMT

Filter the ids in the script?

Re: set analysis expression

Anonymous — Fri, 26 May 2017 17:34:17 GMT

yes filter them in table.(not in script) just display the ones on that condition

Re: set analysis expression

sunny_talwar — Fri, 26 May 2017 17:36:38 GMT

In a single table or limited multiple table? or throughout the dashboard?

Re: set analysis expression

Anonymous — Sun, 28 May 2017 15:20:03 GMT

Sunny thanks again. But what if I need another case like:

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

AND

YEAR_MONTH of the BUS is greater than the YEAR_MONTH of the CAR

Re: set analysis expression

sunny_talwar — Sun, 28 May 2017 17:42:48 GMT

Where are you looking to get this? Would you be able to share a sample and explain where you are looking to get this?

Re: set analysis expression

Anonymous — Sun, 28 May 2017 18:24:33 GMT

the same situation, my aim is to filter the data on that conditions.

hi there,

ı have a table like that :

ID	YEAR_MONTH	category	money
3969385	201502	car	1.206
3969385	201506	bus	2.455
28289815	201502	x	610
22291674	201506	car	1.224
23481102	201506	t	563
10126853	201508	bus	445
360150	201503	r	1.231
1631437	201511	w	523

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

AND

YEAR_MONTH of the BUS is greater than the YEAR_MONTH of the CAR

Re: set analysis expression

sunny_talwar — Sun, 28 May 2017 21:20:58 GMT

But where exactly are you looking to see this info? In a chart or throughout your dashboard or just filter out in the script... I am a little confused

Re: set analysis expression

Anonymous — Mon, 29 May 2017 04:22:11 GMT

in a chart (table) by expression