topic Incremental Reload DOUBT in QlikView

Incremental Reload DOUBT

Fri, 19 Feb 2010 23:26:38 GMT

It is possible make the date comparission on the incremental reload in hour level, because when we put the date with DD/MM/YYYY HH:MM:SS the error script message appear, what can we do about it????

Any help will be appreciate

Regards,

Carlos

Incremental Reload DOUBT

disqr_rm — Sat, 20 Feb 2010 00:03:58 GMT

You may want to look into TIMESTAMP() or TIMESTAMP#() functions and store your date_time fields as numeric value. Then you can compare this numeric value and do incremental loads. Hope this helps.

Incremental Reload DOUBT

Sat, 20 Feb 2010 02:22:41 GMT

Thank You for your answer Rakesh, can i ask you a question?, how can i put a field in a listbox with some restrictions?? For example:

I have this table:

Emp Cta Desc

1 10 Carlos

2 20 Juan

and more rows like this

........

I want to put in the listbox only those who have Cta = 10

Incremental Reload DOUBT

disqr_rm — Sat, 20 Feb 2010 04:09:15 GMT

Right click on th sheet -> New Sheet Object -> List Box

Drop down the Field --> Select <Expression>

Type Expression: if(Cta=10, Desc)

Should work fine.

Incremental Reload DOUBT

Sat, 20 Feb 2010 19:41:46 GMT

Thank you again Rakesh, it works fine.

Greetings