Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Multiple Header Rows Handling

Hi,

How to handle multiple header rows of xls sheet in qlikview.

      

CountrysalessalessalessalessalesProfProfProfLosLosLos
8/8/20159/8/201510/8/201511/8/201512/8/20158/8/20159/8/201510/8/20158/8/20159/8/201510/8/201511/8/2015
IND100120120150125201523000
UK120150150130120502596000
USA150130130160150301436000
UAE130160160160130251236000
JP160160190190160255136000
FR190190130130125362325000
SL130130120150150522525000
MA155155150130130961245000
SG162130130120300522625000

How to separate corresponding date of those columns.

Thanks

Tags (2)
6 Replies
Highlighted

Re: Multiple Header Rows Handling

Hi Hari,

Did you check this Document?

multi_header_pivot_import.qvw

Highlighted
Creator II
Creator II

Re: Multiple Header Rows Handling

Hi,

This can be done by simple drag in pivot table .If you want some exact results to be acquired in such charts means go for aggr.

else

provide some sample application .

thanks,

bunny

Highlighted
Creator III
Creator III

Re: Multiple Header Rows Handling

Hi bunny,

I'm aware of this, but i have to handle this in script!!!

Thanks

Highlighted

Re: Multiple Header Rows Handling

Hi Hari,

Check the attachment..May be helps..

Capture.JPG

Highlighted
Master II
Master II

Re: Multiple Header Rows Handling

Hi hari,

Can you explain a bit about the sheet you have?

1.Why do you have a date below country field?

2. Is it possible to change the layout of the sheet a bit? If yes, then you can use cross table logic.

In place of date "8/8/2015" you can call it Country and you can break this main sheet into two cross table in qlikview.

One having sales and one having prof.

Hope it works.

Regards

KC

Best Regards,
KC
Highlighted
Specialist
Specialist

Re: Multiple Header Rows Handling

Hi Hari

Is your question resolved?

Sreeni