Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikBeginner1
Creator
Creator

Dimension with set analysis

Hello,

This may be very simple and I am overthinking this,

I have a measure, which is a sum and has some set analysis which generates that measure. However, I do not want an aggregated view, which means I have to use this as a Dimension instead of a Sum of the measure so I can see each record instead of a aggregated view of that record.

How can I add the set analysis into the dimension so I have that view?

Sum({$<APEYearAndMonth={">=$(=vStartDate)<=$(=vPriorAPE)"}, DateType={'FKCDate'},SProfitCentre= {'GB00PG002','GB00PG008'}>}Payment)

I want a record of each payment, not aggregated but with the above criteria, where the APEYearandMonth = those values and the DateType and SProfitCentre = those values? Thanks in advance

Labels (4)
1 Reply
marcus_sommer

You could keep this expression by adding an appropriate atomic dimension(s) to your table - maybe a PaymentID.

- Marcus