topic Re: Calendar problem in QlikView

Calendar problem

saumyashah90 — Fri, 08 Mar 2013 12:21:56 GMT

if i want to add date condition in calclated dimension for field name Dt

what should be my expression?

I have D

Dt={'>=$(Start_Date <=$(End_Date)' }

Re: Calendar problem

sushil353 — Fri, 08 Mar 2013 12:23:25 GMT

Use

Dt={">=$(Start_Date) <=$(End_Date)'"}

Re: Calendar problem

Gabriel — Fri, 08 Mar 2013 12:26:35 GMT

Hi,

even though am not sure I fully comprehend your question, however, I will suggest you wrap your expression up in IF function.

Also, if you can possibly explain more in details what you want, might be helpful to the communnity.

Regards,

Gabriel

Re: Calendar problem

saumyashah90 — Fri, 08 Mar 2013 12:26:36 GMT

Its not showing any thing...expression is also not ok

Re: Calendar problem

saumyashah90 — Fri, 08 Mar 2013 12:29:13 GMT

See we have calendar option in which we have two variables Start_Date nd End_Date ,Now we are using a straight table in which there is one dimesion as "Dt"

So we want this dimesnion to fall in between those calendar conditions or range i.e Start_Date & End_Date.

Re: Calendar problem

er_mohit — Fri, 08 Mar 2013 12:56:38 GMT

try this

= '>=' & vStartDate & '<=' & vEndDate

here,vStartDate and vEndDate is my variable

Re: Calendar problem

jagan — Fri, 08 Mar 2013 13:04:29 GMT

Hi Saumya,

Try like this

=Aggr(If(Dt >= Start_Date AND Dt <= End_Date, Dt, Null()), Dt))

Hope this helps you.

Regards,

Jagan.