Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a dought in pivot table.
Let me explain, i have a dimensions are
1)Zone
2)Region
3)District
4)Territory
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:
dimension | sales | target |
South(zone) | ||
KNA(Region) | ||
Ban(district) | ||
hol(territory) | ||
hos(territory) | ||
Mang(district) | ||
jie(territory) | ||
nejk(territory) | ||
TN(Region) | ||
Chen(District) | ||
pon(territory) | ||
bje(territory) | ||
Kan(district) | ||
civ(territory) | ||
ehio(territory) | ||
KER(Region) | ||
Koch(district) | ||
bnajs(territory) | ||
kott(territory) | ||
Trin(district) | ||
njew(territory) | ||
jewq(territory) | ||
APS(Region) | ||
Cht(district) | ||
qiore(territory) | ||
njke(territory) | ||
Cud(district) | ||
njwqd(territory) | ||
notew(territory) |
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).
regrds,
baru
Hi Baru,
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?
Miguel
Hi Miguel,
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,
regards,
baru
Hi,
can anyone have idea about this...!
thanks in advance,
regards,
baru
hi baru...
I am trying to undrstnd ur requirment bt nt sure what u want....bt have alook i tried sumthng....
Let me knw....
regards,
Vaibhav
Hi Vaibhav,
Thanks for your reply,
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.
thanks,
regards,
baru