Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

How to load a cross table with two headers?

Hi all,

I have a cross table which has two headers rows. I now couldn't understand How to load that into the database & make it a straight table format. Please suggest.

Thanks in advance.

Amar .

16 Replies
Not applicable

Hi, I think so!

Not applicable

Wow I've wasted so much time using Excel because I thought you couldn't do this.. but I still don't know how to do it from your example.  How did you do that!?!?!?!?

Not applicable

Well I read the little "Designer II" book and figured it out.. you drag the dimension above the EXPRESSION.

This is actually going to save me an hour today so thanks a lot.

Not applicable

Hi, could you share the excels files to learn it better.

Thanks by advance!

amars
Specialist
Specialist
Author

Hi Kostin,

I know this thing. I wanted to use the excel file as my datasource, for which I will need to use the crosstable function.

I don't want to show a pivot just like the excel but need to import an excel which looks like this, in qlikview dashboard.

Please help. Thanks in advance.

Amar

Not applicable

Hi, you can download Excel from first message by amars.

Not applicable

Hi, I cut the original file into three parts and then joined the parameter "atr". The first part of this is the first title, the second - the second heading, the third - the main body of data.

Not applicable

Hi, amars,I do not understand what you need. Can this option is suitable?

qliksus
Specialist II
Specialist II

Hi ,

Go through the attached file and see whether this is what you want