Need help for set analysis with three parameters

[Anonymous]

Hi Qlikers,

I need your help finding my fault on expressing the right formula. But from the beginning:

I have a table like this one:

date	direction	agency	action	straight	ID_98	ID_99	#1	#2	#3	#4	#5	#6	ID_1	ID_2	ID_3	ID_4	ID_5	ID_6
11/10/2015	Inbound	984500	KVP	8006649423	00980000000512613432	11804	1			1	1		12000	17009	17010	17011	10008	0098000000051261343210008
11/10/2015	Inbound	984500	KVP	8006649423	00980000000512614242	11510	1						12000	17009	17010	17011	10008	0098000000051261424210008
11/10/2015	Inbound	984500	KVP	8007242649	00980000000512615879	11549	1						12000	17006	17007	17008	10008	0098000000051261587910008
11/10/2015	Inbound	984500	KVP	8007242505	00980000000512617172	11801	1						12000	17009	17010	17011	10008	0098000000051261717210008
11/10/2015	Inbound	984500	KVP	8006649423	00980000000512620266	11801	1						12000	17009	17010	17011	10008	0098000000051262026610008
11/10/2015	Inbound	984500	KVP	8006649401	00980000000512620465	11549	1						12000	17009	17010	17011	10008	0098000000051262046510008
11/10/2015	Inbound	984500	none	8006649117	00980000000512614629	11804	1			1	1		12000	17006	17007	17008	10008	0098000000051261462910008
11/10/2015	Inbound	984500	none	8006649117	00980000000512614629	11805	1				1		12000	17006	17007	17008	10008	0098000000051261462910008
11/10/2015	Inbound	984500	none	8006649117	00980000000512615826	11510	1						12000	17009	17010	17011	10008	0098000000051261582610008
11/10/2015	Inbound	984500	none	8006649403	00980000000512620249	11800	1			1			12000	17006	17007	17008	10008	0098000000051262024910008
11/10/2015	Inbound	984500	none	8006649403	00980000000512620117	11801	1						12000	17009	17010	17011	10008	0098000000051262011710008

My ex is this one:

Count( { < [#1]={1}, ID_1={12000}, ID_5={10008} > } ID_98 )

My dimension is

"action"

If I produce a table with this dimenion and a meassure ("Value_1") with this ex above, I'll get 2 values:

Action     Value_1

KVP        6

none        4

I am confused because for the dimension "none" I am counting 5, not 4 as it was calculated by the ex. I tried to count other fields, ie agency or ID_6 but the output for "Value_1" was the same every try.

Unfortunatelly I cannot manipulate the given rawdata, to avoid dublicates, because dublicates should also be kind of the counted value.

Where is my fault? I hope you guys can stick my nose of the root cause.

I'll thank you very much for your help.

T.

P.S. Please excuse me, I hope my english is understandable

[sunny_talwar]

With you data, I am seeing it 6 and 5 ->

[Gysbert_Wassenaar]

I can't reproduce this with the data you provided. Your expression returns a count of five for action value 'none'. See attached app.

[Anonymous]

I have to thank you for your time for taking care of my little problem - I have to apologize also because the given details were not as accurate as they should be. There are much more datasets and different possibilities of two or more ID_98-dublicates.

Nevertheless - I've found my fault: at first step I had the oppinion that I could count ID_98 and it would be nice. But the described value was the "reaction". Now I am doing this:

Count({<.......>} Distinct (IB_9 & ID_98))

...and it works for me.

As above - thanks a lot!

Best regards

T.