topic Re: Set analysis eXpression in Qlik Learning Discussions

Set analysis eXpression

mario-sarkis — Tue, 17 Mar 2015 07:49:13 GMT

hey ALL

i have a problem in how to write the following expression :

i have two field first one is the 'clientID' and the seconde field is the 'Destination ClientID'.

there is a transfer of produts between the 'clientID' and the 'Destination ClientID' , i need to calculate the Sum of Products transfered but with condition that the 'Destination ClientID' should be Different then The ClientID (to disregard the transfer between the sameIDs) i need to calculate id without using a Variable if it's Possible .

Help

Thanks

Re: Set analysis eXpression

Gysbert_Wassenaar — Tue, 17 Mar 2015 08:35:56 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Set analysis eXpression

mario-sarkis — Tue, 17 Mar 2015 08:52:27 GMT

hi Gysbert this is my expression

can you check please if there is anything wrong about it coz it didn't show a result

(count
(
   distinct
   {
    <
     [H_IsCompliance_Specific]= {1},
     [Is Reversal]= {0},
     [Is_Substracted]= {0},
     [Destination Client ID] <>[Classification Client ID]
    >


   }
   [Transaction Key Str])

-count
(
   distinct
     {
      <
       [H_IsCompliance_Specific]= {1},
       [Is Reversal]= {0},
       [Is_Substracted]= {1},
       [Destination Client ID] <> [Classification Client ID]
         >
     }
    [Transaction Key Str]))

Re: Set analysis eXpression

Gysbert_Wassenaar — Tue, 17 Mar 2015 09:07:08 GMT

Apparently you can't.

Perhaps you're running into the problem described in this document: set_analysis_intra-record.qvw

Re: Set analysis eXpression

mario-sarkis — Tue, 17 Mar 2015 10:23:45 GMT

Thank you Gysbert Wassenaar this is exactly what i need to solve my prob.Thank you:)