topic Date comparison not working in QlikView

Date comparison not working

Wed, 05 Mar 2014 09:23:09 GMT

I have a variable

vCurrPeriodEnd , vCurrPeriodStart date variable

VPrevPeriodEnd =if(_CompareType='Year over Year',

date(AddYears(vCurrPeriodEnd,-1))

,date(vCurrPeriodStart-1))

and I am using it like this

Period={">=$(=$(Daystart(vPrevPeriodStart)))<=$(=$(Daystart(vPrevPeriodEnd)))"}

I am putting this in a Set analysis and its not working.

Re: Date comparison not working

MK_QSL — Wed, 05 Mar 2014 09:26:37 GMT

Period={">=$(=$(Daystart('vPrevPeriodStart')))<=$(=$(Daystart('vPrevPeriodEnd')))"}

Period = {'>=$(Daystart('vPrevPeriodStart')) <= $(=Daystart('vPrevPeriodEnd'))'}

Re: Date comparison not working

jagan — Wed, 05 Mar 2014 09:32:59 GMT

Hi,

The formats are same for Daystart(vPrevPeriodStart) and Period dimension, if they are not same then convert by using

Date(Date#(Period, "DateFormat")) or Timestamp(TimeStamp#(Period, "DateFormat"))

Regards,

Jagan.

Re: Date comparison not working

Wed, 05 Mar 2014 09:48:34 GMT

hi anil,

please check your both dates in Text box, look whether both they are in Same format

Re: Date comparison not working

msteedle — Thu, 06 Mar 2014 13:45:50 GMT

There is no such things as a date variable in QlikView, as variables do not have data types. That may be part of the problem, as date comparisons in Set Analysis require you to have identical formatting between the field and the comparison value (your variable), which may not match in your application.

I would suggest plugging that formula into the expression of a straight table. Do not give the expression a label, and the expression label will show your formula after dollar sign expansion/text replacement, helping you see how QlikView is evaluating your logic.

There's not enough information about your data, variables, or their values and formatting to definitively answer your question.