topic Re: Idenitifying dates after today in QlikView

Idenitifying dates after today

Sunil_Kenth — Fri, 19 Aug 2011 15:21:38 GMT

Hi,

I have a pivot table with a order date in. I would like to use visual cues to identify dates that are after todays date - what is the expression that i need to use in the visual cues tab?

Thanks

Idenitifying dates after today

swuehl — Fri, 19 Aug 2011 15:36:38 GMT

Order Date is a dimension, right?

Do you want to colour the dimension values or the cells with expression?

Either way, I would extend the dimension / expression attributes by clicking the '+' sign next to, the add an expression for background color like:

= if (OrderDate > today(), red())

Regards,

Stefan

Re: Idenitifying dates after today

Sunil_Kenth — Fri, 19 Aug 2011 15:42:31 GMT

Hi Stefan,

I tried what you suggested but no luck – it doesn’t make any difference to the formatting of the cells that are in the future.

Any ideas?

Thanks,

Sunil

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. QlikTech UK Limited, registered in England and Wales with number 5292408, and whose registered office is Villiers House, Clarendon Avenue, Leamington Spa, Warwickshire, CV32 5PR.

Idenitifying dates after today

its_anandrjs — Fri, 19 Aug 2011 15:49:59 GMT

Hi skh,

You need to select date field and put the code Today() in the >= text box in visual cues tab and set ie, Upper part and set color which ever you want green or red as well as check mark bold this are done on the date filed that you have.

Regards,

Anand

Re: Idenitifying dates after today

swuehl — Fri, 19 Aug 2011 15:52:47 GMT

Please have a look at attached sample.

Stefan

Re: Idenitifying dates after today

its_anandrjs — Fri, 19 Aug 2011 16:03:27 GMT

Hi,

See the attached sample file and Visual Cues setting.

Hope this helps you

Anand