3 Replies Latest reply: Dec 2, 2015 7:25 PM by Thomas Schmidt RSS

    Need help for set analysis with three parameters

    Thomas Schmidt

      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