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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

Date selection both dimension

Hi guys,

I want to calculate a measure when both 2-dimensional values ​​are included on the selected dates.



for example: calculate the purchased when both the invoice and the order were made in September and August.



Give me help?


Thanks.

3 Replies
bbmmouha
Creator
Creator

it s not clear please give us more details

sum({<month = {'August','September'}> purchased}

s_santalucia
Partner - Creator
Partner - Creator
Author

it is not correct.



suppose I place an order in September and the bill is in October.

if I select the months of September I must have 0 
purchased because the bill is not September

bbmmouha
Creator
Creator

print screen or an exemple please

i can't help you like this