Logic

[#1]

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

[swuehl]

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)

[Anonymous]

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