Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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