Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Logic

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

2 Replies
MVP
MVP

Re: Logic

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)

gupta_n8
Valued Contributor II

Re: Logic

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

Community Browser