Multiple Header Rows Handling

[hariprasadqv]

Hi,

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

Country	sales	sales	sales	sales	sales	Prof	Prof	Prof	Los	Los	Los
8/8/2015	9/8/2015	10/8/2015	11/8/2015	12/8/2015	8/8/2015	9/8/2015	10/8/2015	8/8/2015	9/8/2015	10/8/2015	11/8/2015
IND	100	120	120	150	125	20	15	23	0	0	0
UK	120	150	150	130	120	50	25	96	0	0	0
USA	150	130	130	160	150	30	14	36	0	0	0
UAE	130	160	160	160	130	25	12	36	0	0	0
JP	160	160	190	190	160	25	51	36	0	0	0
FR	190	190	130	130	125	36	23	25	0	0	0
SL	130	130	120	150	150	52	25	25	0	0	0
MA	155	155	150	130	130	96	12	45	0	0	0
SG	162	130	130	120	300	52	26	25	0	0	0

How to separate corresponding date of those columns.

Thanks

[settu_periasamy]

Hi Hari,

Did you check this Document?

multi_header_pivot_import.qvw

[Anonymous]

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

[hariprasadqv]

Hi bunny,

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

Thanks

[settu_periasamy]

Hi Hari,

Check the attachment..May be helps..

[jyothish8807]

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

[SreeniJD]

Hi Hari

Is your question resolved?

Sreeni