Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor

Set analysis eXpression

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

1 Solution

Accepted Solutions

Re: Set analysis eXpression

Apparently you can't.

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


talk is cheap, supply exceeds demand
4 Replies

Re: Set analysis eXpression

Can you post a qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
mario-sarkis
Contributor

Re: Set analysis eXpression

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

Apparently you can't.

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


talk is cheap, supply exceeds demand
mario-sarkis
Contributor

Re: Set analysis eXpression

Thank you Legend

Community Browser