topic Re: Date comparison in QlikView

Date comparison

Mon, 18 Mar 2013 02:36:45 GMT

I have a input control which stores date in a variable say vDate. I have two fields Inception Date and Expiration Date. Based on the value in input control I need to get the results in Straight table or Pivot table with the condition Where Inception Date>= vDate and Expiration Date <= vDate.

Re: Date comparison

Mon, 18 Mar 2013 04:26:07 GMT

try this if(Inception Date>= vDate and Expiration Date <= vDate,DimName)

Re: Date comparison

sushil353 — Mon, 18 Mar 2013 04:51:52 GMT

hi,

If you want to use this condition for an expression then u can use set analysis:

sum({<Inception Date={">=$(vDate)"},Expiration Date={"<= $(vDate)"}>}FACT)

and if you want to use in dimention then you can follow expression as given by nirmal.

if(Inception Date>= vDate and Expiration Date <= vDate,DimName)

HTH

Sushil

Re: Date comparison

Mon, 18 Mar 2013 04:56:06 GMT

I got this working by using below.

sum({<InceptionDate={"<=$(vDate)"},ExpirationDate={">=$(vDate)"}>}Sales)