Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is it possible to load different datas to 2 tab.
say i have 2 table Qliktest1 and qliktest2
Qliktest1 having columns col1,col2,col3
and qliktest2 having coumns Qcol1,qcol2
my query is i want to load data from qliktest1 to sheet1 and display as a chart and display qliktest2 in sheet2 as a table .
i dont want the columns to display on both sheets.
is ther any way to do so.
If so kindly advice.
Thanks in Advance..
With Regards
Deepak Subramoniam
Hi,
Simply load both tables into the Application without any link to each other.
Create the first sheet with first table and second sheet with second table. As far as there is no link to the tables both sheets wont be disturbed by each other.
Hope this helps.
Thanks.
Simple example:
Table1:
LOAD *
Inline [
A, B
1, 3
2, 4
]
;
QUALIFY *;
Table2:
LOAD *
Inline [
A, B
1, 3
2, 4
]
;
UNQUALIFY *;
After reloading the data your table schema is:
In this case you can create two different charts independently as they are in any way connected.
Also, instead of Qualify/Unqualify statement you can rename the fields.
ya its Worked fine.
thanks a lot.
this is to add 1 point that , i learned from qlikview. i can have have a single column of data in 2 different name but cant use a column name of same name in two tables.
say an example
i have a table with columns col1,col2,col3
select col1 as 'Q1',col1 as 'Q2'
from qtable;
the above statement will work fine.
while
select col1 from qtable1
select col1 from qtable2
now qlik view will display col1 from table alone as fields and it wont show 2 cols
for that we can rewrite like
select col1 as 'Q1' and col2 as 'Q2' from qtable.
this is my learning alone
Thanks in Advance...
With Regards
Deepak Subramoniam