Forum Discussion

neto22's avatar
neto22
New Member
4 years ago
Solved

Sum Distinct with condition

Hello guys,   Qlik has a language called set analysis, which allows you to create formulas through conditions.   SUM({$<[Limit Flg] = {'S'}>}DISTINCT(NUM(CEIL([Last Original Limit]))))))   I'm ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi neto22 ,

     

    I try to learn set analysis in Qlik and understand it's calcualte logic by myself. And I think you are trying to sum the [Last Original Limit] with out duplicates (Distinct) with the condition that [Limit Flg] = "S".

    I suggest you to try this code.

    My Sample:

    Measure:

    Convert the code = 
SUMX (
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Limit Flg] = "S" ),
        'Table'[Last Original Limit]
    ),
    [Last Original Limit]
)

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi neto22 ,

 

I try to learn set analysis in Qlik and understand it's calcualte logic by myself. And I think you are trying to sum the [Last Original Limit] with out duplicates (Distinct) with the condition that [Limit Flg] = "S".

I suggest you to try this code.

My Sample:

Measure:

Convert the code = 
SUMX (
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Limit Flg] = "S" ),
        'Table'[Last Original Limit]
    ),
    [Last Original Limit]
)

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.