Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Creator
Creator

Re: Date selection both dimension

it s not clear please give us more details

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

Highlighted
Partner
Partner

Re: Date selection both dimension

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

Highlighted
Creator
Creator

Re: Date selection both dimension

print screen or an exemple please

i can't help you like this