topic Limit Dimension by Date in QlikView

Limit Dimension by Date

danielnevitt — Wed, 11 Sep 2013 09:10:06 GMT

Hi,

I am trying to limit a straight table by a dimension date.

The code I have written is =If(PRICING1_END_DT<=vToday,PRICING1_END_DT))

This isn't quite correct and it just removes the date if it is after vToday. I would like the table to only show data where the PRICING1_END_DT is less than today, rather than blank the data in the field.

Any help is much appreciated.

Regards,

Daniel

Re: Limit Dimension by Date

simondachstr — Wed, 11 Sep 2013 09:12:58 GMT

Can you tell us something about the format of PRICING1_END_DT and vToday.

Re: Limit Dimension by Date

danielnevitt — Wed, 11 Sep 2013 09:17:07 GMT

Hi Martin,

Thank you for your reply.

vToday = Date(Today()) - format of this field is DD/MM/YYYY

PRICING 1_END_DT is a date field in the format of DD/MM/YYYY

Is that all the information you require?

Regards,

Daniel

Re: Limit Dimension by Date

Gysbert_Wassenaar — Wed, 11 Sep 2013 09:18:47 GMT

Try putting the limit in the expression. Suppose you want sum(Value) as expression. You can limit this to the required dates like this: sum({<PRICING1_END_DT={'<=$(vToday)'}>}Value)

You'll have to make sure that the variable vToday has the same date format as PRICING1_END_DT

Re: Limit Dimension by Date

simondachstr — Wed, 11 Sep 2013 09:24:03 GMT

Are Suppress Zero-Values & Suppress When Value is Null checked?

Re: Limit Dimension by Date

danielnevitt — Wed, 11 Sep 2013 09:29:09 GMT

Hi,

Thanks that has solved the issue. Sorry for not spotting this basic error.

Regards,

Daniel