Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please check whether the below condition is correct or not
If(Date(aggr(Max(S_Date) ,U_ID),'DD-MM-YYYY')>=Date('01-04-2016','DD-MM-YYYY'),'True','False')
If its greater than 01-04-2016 then True else False
Regards,
Keerthi KS
Hi Keerthi,
It depends on where you use it, if you use it on a graph where the dimension is u_id, yes, it is almost correct. You don't need Aggr function.
If(Date(Max(S_Date),'DD-MM-YYYY')>=Date('01-04-2016','DD-MM-YYYY'),'True','False')
But, it is better that you attach your application to view and analyze it.
Regards!
use date# to interpret it as date and compare with Actual date field
If(Date(aggr(Max(S_Date) ,U_ID),'DD-MM-YYYY')>=Date#('01-04-2016','DD-MM-YYYY'),'True','False')
try using
Date# function insted of Date
I have used aggr(Max(S_Date) ,U_ID) as Calculated Dimension in my table. I want to display True if S_Date is greater than 01-04-2016 else False.
But when i use the condition Dimensions will be displayed twice.
Can you try this as your expression:
If(Max(S_Date) >= MakeDate(2016, 4, 1), 'True', 'False')