Set analysis eXpression

[mario-sarkis]

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

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[mario-sarkis]

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]))

    

[Gysbert_Wassenaar · Accepted solution]

Apparently you can't.

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

[mario-sarkis]

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