Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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
MVP
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