INLINE Template

[manishapanda1]

Hi All,

i have following requirement in Qliksense .Please help me to get the solution.

user requirement :

User o want the ability to Export and Print this report to a single sheet.

report details :

1.there are couple of SQL query which helps to get the details to Qliksense-(query is already written and desired data also available in qliksense after loading the query).

2.There are total 30 tables generated through the sql query.

3. now the challenge is the 1st column field names starting from title1 to title 2 total is not mentioned any where in the script , i need to define them to give meaning to (NV,DD,CI.......Total).NV,DD,CI....... field names of the tables which generated through sql query.all the table have same field name with different  numbers eg :

table1:

NV

DD

CI

EE

JJ

FF

BB

1            2          3            4        6       8             9

Table2:

NV

DD

CI

EE

JJ

FF

BB

7            3          5        1             4           8       10          so on till table 30 with different value.

Tried solution :

I have created a inline table

load *inline

[ title1

ipd,

ips,

np,

total

]

load *inline

[title2

nnn,

vbpp

];

and used that in the table , so now i got my label names.then i am doing pick & wildmatch to get the nv dd....bb values against ipd ,ips,and np. but not getting the correct result.

table sample:

Summary table
NV	DD	CI	EE	JJ	FF	BB	Total	NV	DD	CI	EE	JJ	Total
title1
ipd	123	124	125	126	127	128	129	882
ips	235	236	237	238	239	240	241	1,666
np	436	437	438	439	440	441	442	3,073
Total	794	797	800	803	806	809	812	5,621
title2
nnn									557	558	559	560	561	2,795
vbp									658	659	660	661	662	3,300
Total									1,215	1,217	1,219	1,221	1,223	6,095
Value Ref Table
NV_01	DD	CI	EE	JJ	FF	BB	NV_OH	DD_OH	CI_OH	EE_OH	JJ_OH	FF_OH	BB_OH
-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------
123	124	125	126	127	128	129	130	131	132	133	134	135	136
NV_02	DD	CI	EE	JJ	FF	BB	NV_OH	DD_OH	CI_OH	EE_OH	JJ_OH	FF_OH	BB_OH
-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------
234	235	236	237	238	239	240	241	242	243	244	245	246	247
NV_02	DD	CI	EE	JJ	FF	BB	NV_OH	DD_OH	CI_OH	EE_OH	JJ_OH	FF_OH	BB_OH
-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------
435	436	437	438	439	440	441	442	443	444	445	446	447	448
NV_02	DD	CI	EE	JJ	FF	BB	NV_OH	DD_OH	CI_OH	EE_OH	JJ_OH	FF_OH	BB_OH
-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------
556	557	558	559	560	561	562	563	564	565	566	567	568	569
NV_02	DD	CI	EE	JJ	FF	BB	NV_OH	DD_OH	CI_OH	EE_OH	JJ_OH	FF_OH	BB_OH
-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------	-----------
657	658	659	660	661	662	663	664	665	666	667	668	669	670