topic Re: Need to Create a Inline Table in QlikView

Need to Create a Inline Table

Anonymous — Thu, 25 Sep 2014 15:21:21 GMT

Hi,

Need to Create a inline table with the below Data.Getting Problem in the Expression Values

Could anyone help in Creating a inline table with the below 2 fields and their values.

Test:

Load * inline

[

ExpId, Expression

0,Above([Field1],0)*$(vVar(0)),

1,Above([Field1],1)*$(vVar(1)),

2,Above([Field1],2)*$(vVar(2)),

];

Thanks in Advance.

Re: Need to Create a Inline Table

jerem1234 — Thu, 25 Sep 2014 16:26:59 GMT

You can use a mapping (it doesn't like the characters '[' and ']' in your inline table, also the $ is trying to evaluate the variable). Just use different characters for those characters, then map them back like:

map1:

Mapping Load x, pick(match(x, '<', '>', '!'), '[', ']', '$') as y Inline [

];

Test:

Load ExpId, MapSubString('map1', Expression) as Expression inline

[

ExpId, Expression

0,'Above(<Field1>,0)*!(vVar(0))'

1,'Above(<Field1>,1)*!(vVar(1))'

2,'Above(<Field1>,2)*!(vVar(2))'

];

Please find attached.

Hope this helps!

Re: Need to Create a Inline Table

perumal_41 — Thu, 25 Sep 2014 17:03:44 GMT

Hi Karthigayan,

table put into excel and load in qlikview ,instead punting inline table .

PFA .

Re: Need to Create a Inline Table

Thu, 25 Sep 2014 17:44:30 GMT

You can try something like this or refer this link ABOVE Function

Test:

Load * inline

[

ExpId, Expression

0,Above(ExpId,0)*$(vVar(0))

1,Above(ExpId,1)*$(vVar(1))

2,Above(ExpId,2)*$(vVar(2))

];