Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

SJ_16
New Contributor

Measure Calculation

Hi,

I want a formula within my measure to say

if Date_In equals Quota_Date then total_val

Is this possible please?

2 Replies
ychaitanya
Contributor III

Re: Measure Calculation

have you tried

Sum(If( Data_In=Max(Quota_Date),Total_Val))

jubarros
Contributor II

Re: Measure Calculation

Hi:

Sum({<Data_In={">=$(=max(Quota_Date))<=$(=max(Quota_Date))"}>} Total_Val)

Best Regards,

Juan P. Barroso

Community Browser