Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with an Expression.

Hi,

My data contains an OrderEndDate, OrderStartDate, OrderNumber.

I calculated the number of days using the expression : [OrderEndDate]-[OrderStartDate] and named it as Date_difference.

Now the next step I want is,

For a given OrderEndDate,  get a list of OrderNumber on that date and also get the sum of Date_difference.

I need help with this and which expression I should write.

Thank you.

2 Replies
damirm86
Partner
Partner

Can we see your data?

bellamae
Specialist
Specialist

you should only need sum([Date_difference]) but it will depend on how you are trying to display it.

If you are using a table or line graph then OrderEndDate will be your dimension and sum([Date_difference]) will be your measure.

If you are using a KPI object then you will need a filter box with OrderEndDate as sum([Date_difference]) will default to all records.