Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a dought in pivot table.
Let me explain, i have a dimensions are
it is all from one table...
I know, in qlikview we can create a pivot table like this:
But,I want to look like this report in qlikview is:
is it possible to call 4 dimnsion as a one dimension in pivot table hierarchy which i mensioned in the above.
Please share me your ideas about this.
I am attaching my sample application(pfa).
Did you try creating a cyclic or drill down group? Go to the settings menu, Document Properties, Groups tab and create a new drill-down group, where you add Zone, Region, District and Territory. Then use this group as dimension in your chart.
Does that suit you?
Thanks for your reply,
Acctually my client is asking this Hierarchy,which i shown above.They want to see this in one report at a time.
Is this possible in qlikview.Let me know about this.
thanks in advance,
can anyone have idea about this...!
I am trying to undrstnd ur requirment bt nt sure what u want....bt have alook i tried sumthng....
Let me knw....
In this application all the field are coming in one olumn it is correct,but my requirement is maintaining the hierarchy that is i shown in the top.