Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Loading 3 dimensional excel sheet

I have a 3 dimensional excel sheet and need to load it in Qlick View (Account, Amount, Date) ....

I have attached a sample of the excel sheet .... any help

Regards,

Tags (3)
1 Reply
Not applicable

Loading 3 dimensional excel sheet

Hi

split the excel into  two excel files

one is for Debit and another is for Credit.

do the crosstable function,

Load separately then join both the tables.

Community Browser