topic Re: Pivot table.... in QlikView

Pivot table....

Wed, 10 Oct 2012 08:55:43 GMT

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

Re: Pivot table....

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 09:00:46 GMT

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

Re: Pivot table....

Wed, 10 Oct 2012 09:15:16 GMT

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

Re: Pivot table....

Wed, 10 Oct 2012 12:15:15 GMT

Hi,

can anyone have idea about this...!

thanks in advance,

regards,

baru

Re: Pivot table....

Anonymous — Wed, 10 Oct 2012 12:31:31 GMT

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

Re: Pivot table....

Wed, 10 Oct 2012 12:54:27 GMT

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