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: 
Not applicable

multiple script for multiple tab

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

3 Replies
arasantorule
Creator III
Creator III

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.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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:

Screenshot_1.jpg

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.

Not applicable
Author

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