Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Insert excel content

Hello everyone !

I have an excel file with a pivot table like that :

CustomerProject
Customer 1Project 1.1

Project 1.2

Project 1.3
Customer 2Project 2.1

Project 2.2

In the excel file, project 1.1, 1.2, 1.3 are all associated with customer 1, and project 2.1 and 2.2 are associated with customer 2.

QlikView only makes the association between customer1 and project 1.1,   and customer2 with project 2.2.

Can I do something without changing the excel file ?

1 Solution

Accepted Solutions
Not applicable

Insert excel content

Yes, You can do this without changing the excel file.

While loading the excel file, you need to do transformation to fill the empty row which is below the customer1 and customer2.

Steps  --> Target you excel fiels by clicking Table File wizard -- > Load your data -- > Say Next from File Wizard : Tye --> File Wizard : TransaFormation --> Say Enable Transformation Steps --> go to Fill Tab--> click "Fill" Button --> Specifiy the target Column and go to Cell Condition and say ok without changing any settings -- > once you say ok, now you`d see the empty rows would have been filled with the informations and say Next and Finsih to come back to edit script.

Reload your application to get the data.

hope this helps you.

-Sridhar

2 Replies
Not applicable

Insert excel content

Yes, You can do this without changing the excel file.

While loading the excel file, you need to do transformation to fill the empty row which is below the customer1 and customer2.

Steps  --> Target you excel fiels by clicking Table File wizard -- > Load your data -- > Say Next from File Wizard : Tye --> File Wizard : TransaFormation --> Say Enable Transformation Steps --> go to Fill Tab--> click "Fill" Button --> Specifiy the target Column and go to Cell Condition and say ok without changing any settings -- > once you say ok, now you`d see the empty rows would have been filled with the informations and say Next and Finsih to come back to edit script.

Reload your application to get the data.

hope this helps you.

-Sridhar

Not applicable

Insert excel content

Yeaaah ! Thank you so much !