Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Apparently you can't.
Perhaps you're running into the problem described in this document: set_analysis_intra-record.qvw
Can you post a qlikview document that demonstrates the problem?
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]))
Apparently you can't.
Perhaps you're running into the problem described in this document: set_analysis_intra-record.qvw
Thank you Gysbert Wassenaar this is exactly what i need to solve my prob.Thank you:)