topic Re: Change "base table" for each tab differently in QlikView

Change "base table" for each tab differently

MikeJohn — Sat, 16 Nov 2024 18:40:19 GMT

Hi,

I have different excel files with different names for each column. e.g.

Excel1:

Col1, Col2, Col 3

Excel2:

Kol1, Kol2, Kol3

Now i do have some Graph which uses the column of Excel1.

I now want to create a second tab and only copy and paste the graph and tell him "all formulars and everything is the same, but use Excel2 as your source".

A general idea would be to import both excels like this:

Excel1:

Col1 as C1, Col2 as C2, Col 3 as C3

Excel2:

Kol1 as C1, Kol2 as C2 , Kol3 as C3

ANd than have somewhere some option to tell him "in this tab, use Excel1 as base table" "in that tab, use Excel2 as base table".

Is that somehow possible?

Re: Change "base table" for each tab differently

settu_periasamy — Sat, 09 May 2020 16:52:05 GMT

Hi @MikeJohn ,

if it is kind of same data, i suggest that, you can concatenate all the excel data into single table with the 'Source Origin'.

e.g.

Final:

Col1 as C1, Col2 as C2, Col 3 as C3,

'Excel1' as Origin From Excel1;

Concatenate(Final)

Kol1 as C1, Kol2 as C2 , Kol3 as C3,

'Excel2' as Origin From Excel2;

So, you can create a single chart. In the Sheet Activate trigger, you can use the field 'Origin'.

goto first tab, 'On Activate Sheet' trigger -> Select In Field ->

Field : Origin

Search of String : Excel1

Like all other tabs. 'On Leave Trigger' -> Clear Field -> Origin