topic Re: Show only date in QlikView

Show only date

prasadreddy — Wed, 24 Jul 2013 07:16:32 GMT

Hi All,

I have the Date field with values

2013-02

2013-03

2013-04

But, i want to display only '2013-04 onwards', before the 2013-04 dont want show,

i have to show this list box in dashboard level,

any one help on this appriciate

Thanx

tresB — Wed, 24 Jul 2013 07:27:31 GMT

Select expression in the 'field' drop down under general tab of list box and write the expression like:

If( DateField >= '2013-04', DateField)

This should work if your date filed is in proper date format.

narender123 — Wed, 24 Jul 2013 07:30:25 GMT

in list box

General>field>expression

write

if(datefileld='2013-04','2013-04','2013-04')

NOw list box only show 2013-04

or if you want date>=2013-04

if(datefileld >='2013-04',datefileld)

Thanks

Narender

prasadreddy — Wed, 24 Jul 2013 07:31:44 GMT

Hi Tres,

I tried this, but it is showing all values in decending order

narender123 — Wed, 24 Jul 2013 07:36:11 GMT

In sort select datefield as ascending

tresB — Wed, 24 Jul 2013 07:38:31 GMT

must be format issue, try this:

If( date#(DateField,'YYYY-MM')>= '2013-04', DateField)

prasadreddy — Wed, 24 Jul 2013 07:42:21 GMT

Hi Tres,

Its working

Thank you