Discussion Board for collaboration related to QlikView App Development.
How to handle multiple header rows of xls sheet in qlikview.
How to separate corresponding date of those columns.
Did you check this Document?
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.
provide some sample application .
I'm aware of this, but i have to handle this in script!!!
Check the attachment..May be helps..
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.
Is your question resolved?