topic Re: Loaded data is not shown in the list in QlikView

Loaded data is not shown in the list

Mon, 09 Mar 2015 16:12:47 GMT

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.

Re: Loaded data is not shown in the list

Anonymous — Mon, 09 Mar 2015 16:14:54 GMT

Iuri,

Please post a sample data.

Marc.

Re: Loaded data is not shown in the list

anbu1984 — Mon, 09 Mar 2015 16:18:22 GMT

Can you post your complete script.

Did you reload the script after you added above Load statement

Re: Loaded data is not shown in the list

Roop — Mon, 09 Mar 2015 16:18:50 GMT

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

Hope it helps

Rupert

Re: Loaded data is not shown in the list

Mon, 09 Mar 2015 17:28:58 GMT

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.

Re: Loaded data is not shown in the list

Mon, 09 Mar 2015 17:30:08 GMT

Hi Anbu,

I will try, thanks for your support.

Re: Loaded data is not shown in the list

Mon, 09 Mar 2015 18:02:56 GMT

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.