Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to Create a Inline Table

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.

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

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 [

x

<

>

!

];

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!

View solution in original post

3 Replies
jerem1234
Specialist II
Specialist II

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 [

x

<

>

!

];

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!

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Karthigayan,

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

PFA .

Not applicable
Author

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))

];