Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loaded data is not shown in the list

Hello,

Have got an issue....

I have loaded the following data:

...

left Join
load
Fulldate,
Mid(Fulldate,1,3) as Month
FROM
$(vPath_Reference_Data)DimTime.qvd
(
qvd);

Then I wanted to create a list box of the Months, but that was not possible since the field month is not there to be choosen. But the Fulldate it is there. Can anyone explain me whats going on?

Thank you very much.


6 Replies
Anonymous
Not applicable
Author

Iuri,

Please post a sample data.

Marc.

anbu1984
Master III
Master III

Can you post your complete script.

Did you reload the script after you added above Load statement

Roop
Specialist
Specialist

Try Month(Fulldate) instead - My guess is that it is a date and that is held numerically.

Hope it helps

Rupert

Not applicable
Author

Hi Rupert,

Thanks for your answer, but still dont work, I think because the date is in Spanish.

The format of the date is "December 2014"

But wanted a list box with Dec, thats is why I used "Mid". In a TextBox if I use Upper function  appears the DEC. It just doest appear in the list box the fiel.

Not applicable
Author

Hi Anbu,

I will try, thanks for your support.

Not applicable
Author

Thanks all for your answers....

I figured out why the field was not being shown.

I was modified an existing App, and it had a hidden on my column, so I just had to comment the part of the script.