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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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