topic Re: Help: How to create a List??? in QlikView

Help: How to create a List???

Tue, 26 Feb 2013 20:46:54 GMT

Hello,

so i want to create a list in Qlikview to show different shift: Morning, After, Night.

the content in this list is not in the server so it have to be created new.

what is the code for this??

the one i have is:

ShiftMap:

select * inline

[

morning,

after,

night

];

is this code correct???

Re: Help: How to create a List???

Tue, 26 Feb 2013 21:03:27 GMT

It depends what you are trying to do with it. From your table name, it looks like you are trying to build a mapping load? That's different and you will need more info. But to just create a table with those three lines, use:

ShiftMap:

LOAD * INLINE [
shift
    morning
    after
    night
];

Re: Help: How to create a List???

Thu, 28 Feb 2013 15:27:35 GMT

Thank you very much it is very helpful!!!!

Re: Help: How to create a List???

Thu, 28 Feb 2013 15:30:56 GMT

The easiest way to create an inline load is to just click Insert > Load Statement > Load Inline in the Script Editor. It will open up a table for you to enter your information. That way you don't have to worry about memorizing the syntax.