topic Re: multiple script for multiple tab in QlikView

multiple script for multiple tab

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: multiple script for multiple tab

arasantorule — Tue, 05 Jul 2016 09:48:52 GMT

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.

Re: multiple script for multiple tab

MindaugasBacius — Tue, 05 Jul 2016 10:10:26 GMT

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.

Re: multiple script for multiple tab

Fri, 08 Jul 2016 11:23:46 GMT

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