Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
karthigayan
Creator II
Creator II

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!

View solution in original post

perumal_41
Partner
Partner

Hi Karthigayan,

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

PFA .

Not applicable

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

];