topic Re: Problem with List Box in QlikView

Problem with List Box

Mon, 24 Mar 2014 13:52:12 GMT

Hi all

i have straight table with some columns.in this Date is also there .so here i am getting the Dates in a Perfect format only in the table. .but the problem is when i take only one field i.e "Date" the dates are not coming . Alternate years are coming. .so how to sort the years like 2011,2012.

I want to do in edit script window itself only. Please find the attachment.

Thanks

Re: Problem with List Box

Nicole-Smith — Mon, 24 Mar 2014 13:55:43 GMT

QlikView is actually treating your date as a text field. In your dashboard, you need to either:

a) SET DateFormat='DD/MM/YYYY'; (in your load script)

b) When loading the date in, let QV know it is a date: date#(Date,'DD/MM/YYYY') as Date

c) Go to Document Properties > Number and set the Date field as a Date

d) On the list box, choose a calculated expression: date#(Date,'DD/MM/YYYY')

Re: Problem with List Box

SunilChauhan — Mon, 24 Mar 2014 13:57:15 GMT

Date#(Date,'DD/MM/YYYY') as Date

and list box properties -> sort->Numeric-> acsending

list box properties -> sort-> Expression_> write below

Date#(Date,'DD/MM/YYYY')

hope this helps

Re: Problem with List Box

Anonymous — Mon, 24 Mar 2014 13:57:40 GMT

In the object property, sort tab, you can put expression like num(Date) and order as ascending.

Hope it helps.

Re: Problem with List Box

sundarakumar — Mon, 24 Mar 2014 13:57:43 GMT

Hi Roshan,

The data is in Text, convert it to date by

date(date) as date_date

and use the newly created date in the field and go to sort tab and check ascending..

it will work..

-sundar

Re: Problem with List Box

sudeepkm — Mon, 24 Mar 2014 14:00:56 GMT

Have you tried sorting the Date field in the List Box by Numeric Value Asc or Desc.

Re: Problem with List Box

PrashantSangle — Mon, 24 Mar 2014 14:35:34 GMT

Hi,

As Other People suggest you have to convert your date field into date format using date#() in your script

use

date#(date,'DD/MM/YYYY') as Date

Then at end use 'Order By' Clause.

Order By Date;

Regards