Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
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
Contributor III

Re: multiple script for multiple tab

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.

Highlighted
Valued Contributor III

Re: multiple script for multiple tab

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.

Highlighted
Not applicable

Re: multiple script for multiple tab

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