topic Need Advice in QlikView

Need Advice

Tue, 17 Mar 2015 18:17:08 GMT

Hi All,

The format of date is like this [42040],[42041] while loading the data from excel, prior to loading the format of the data in excel is 16-03-2015,15-06-2015.etc..I have formatted cells to date in excel n tried all the possibilities in excel...Is there any option where we can load date as it is...please advice..

Regards,

Krishna

Re: Need Advice

Anonymous — Tue, 17 Mar 2015 18:25:42 GMT

Use date() function when load this field.

Re: Need Advice

robert_mika — Tue, 17 Mar 2015 18:38:11 GMT

What you see in Excel is just format.

Excel stores Dates as values numbers.

Use Micheal advice.

Re: Need Advice

Tue, 17 Mar 2015 19:02:24 GMT

Hi Robert & Michael,

The problem here is I'm able to convert these stuff to proper date format in qlikview, but while using triggers, I'm facing issues...When I'm trying to select set of dates with the selection of some value in another list box... its not happening..

I have used the following expression as trigger

Regards

Krishna

Re: Need Advice

maxgro — Tue, 17 Mar 2015 20:03:22 GMT

instead of trigger you can try with Rob solution here

http://community.qlik.com/message/732989#732989