How can we import pivot excel to Qlikview?

[#1]

Hello,

Find the attachment for the excel model which we are trying to feed thru QlikView.

Once we feed into Qlik we except to establish the relationship between columns across.

Any suggestions on how this can be done?

Thanks.

[Gysbert_Wassenaar]

See attached example.

[#3]

apologies gwassenaar the model is little different on what i am working on which i have realized when the solution that you have provided is not working with the working model.

But to fact the solution that you have provided is the most accurate one.

Please see the attachment where i made exact replica of the model excel.

[priyarane]

you have to play with Enable transformation step - fill - fill - target column - cell condition - below/above - ok

[Michael_Tarallo]

‌hi Dinesh see if this may help you

Power of Qlik Script - Reshaping Data with Crosstable (video)

REgards

mike