topic Re: Logic in QlikView

Logic

Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

In my application source of data is excel, In which there are 5 sheet with same column names.I have created a application(qvw) of 3 tab but now due to some changes I want that my last tab will active for all the 5 excel sheet and the remaining tab works on remaining 4 excel sheet..

So how I create logic for this in qlikview

Regards ,

Rahul

Re: Logic

swuehl — Fri, 20 Dec 2013 14:33:06 GMT

Load your excel data in with an additional field created like

LOAD

1 as SheetNo,

....

FROM

[ExcelFile.xls]

(biff, embedded labels, table is [Tabelle1$]);

LOAD

2 as SheetNo,

....

FROM

[ExcelFile.xls]

(biff, embedded labels, table is [Tabelle2$]);

Then use this field to limit the records in your calculations:

=sum({<SheetNo ={1,2,3,4}>} Value)

=sum({<SheetNo ={1,2,3,4,5}>} Value)

Re: Logic

Anonymous — Tue, 24 Dec 2013 06:38:20 GMT

You can also use by creating a data island for the data loaded from sheet 5.

in this way what ever reports you wiill create with this data isaland will not effect at all on other reports.

Regards

Nitin