Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Set Analysis

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

2 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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

Set modifiers ‒ QlikView

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.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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