Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying write on expression in set analysis.
=Sum({$<Distinct [ASDP Name] =>}[CSNUM])
basically i need For Distinct ASDP Name what is the sum of Numerator.
Can some one help me here.
Best Regards,
HK
If I understand your problem correctly, you don't even need set analisys for that.
Just a simple table, with your data would suffice.
What your doing on your set analysis is removing the selection of the [ASDP Name] dimension.
Example from Qlik Help
sum( {$<Region = >} Sales ) | Returns the sales for the current selection, but with the selection in 'Region' removed |
See the attached file for example.
Best regards,
Felipe.
Hi,
If you create a chart, of type Straight Table, with ASDP Name this will inherently give you a distinct list of values in that field. The expression does not need a DISTINCT statement or Set Analysis, simply:
=Sum([CSNUM])
I don't think that DISTINCT can be used with Sum (it only makes sense with Count), also where it is used it should be outside of the Set, i.e. before or after the {}.
Hope that helps.
Steve