Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

t_schmidt
Not applicable

Need help for set analysis with three parameters

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:

          

datedirectionagencyactionstraightID_98ID_99#1#2#3#4#5#6ID_1ID_2ID_3ID_4ID_5ID_6
11/10/2015Inbound984500KVP8006649423009800000005126134321180411112000170091701017011100080098000000051261343210008
11/10/2015Inbound984500KVP80066494230098000000051261424211510112000170091701017011100080098000000051261424210008
11/10/2015Inbound984500KVP80072426490098000000051261587911549112000170061700717008100080098000000051261587910008
11/10/2015Inbound984500KVP80072425050098000000051261717211801112000170091701017011100080098000000051261717210008
11/10/2015Inbound984500KVP80066494230098000000051262026611801112000170091701017011100080098000000051262026610008
11/10/2015Inbound984500KVP80066494010098000000051262046511549112000170091701017011100080098000000051262046510008
11/10/2015Inbound984500none8006649117009800000005126146291180411112000170061700717008100080098000000051261462910008
11/10/2015Inbound984500none800664911700980000000512614629118051112000170061700717008100080098000000051261462910008
11/10/2015Inbound984500none80066491170098000000051261582611510112000170091701017011100080098000000051261582610008
11/10/2015Inbound984500none800664940300980000000512620249118001112000170061700717008100080098000000051262024910008
11/10/2015Inbound984500none8006649403009800000005126201171180111200017009170101701110008

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

3 Replies
stalwar1
Not applicable

Re: Need help for set analysis with three parameters

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

Capture.PNG

Gysbert_Wassenaar
Not applicable

Re: Need help for set analysis with three parameters

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

t_schmidt
Not applicable

Re: Need help for set analysis with three parameters

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.