topic Date greater than condition in QlikView

Date greater than condition

Tue, 14 Jun 2016 06:58:57 GMT

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

Anonymous — Tue, 14 Jun 2016 07:10:25 GMT

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!

Kushal_Chawda — Tue, 14 Jun 2016 07:22:12 GMT

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')

Chanty4u — Tue, 14 Jun 2016 07:24:21 GMT

try using

Date# function insted of Date

Tue, 14 Jun 2016 08:37:53 GMT

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.

sunny_talwar — Tue, 14 Jun 2016 09:57:34 GMT

Can you try this as your expression:

If(Max(S_Date) >= MakeDate(2016, 4, 1), 'True', 'False')