Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot table....

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:

dimensionsalestarget
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

5 Replies
MVP
MVP

Re: Pivot table....

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

Not applicable

Re: Pivot table....

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

Not applicable

Re: Pivot table....

Hi,

can anyone have idea about this...!

thanks in advance,

regards,

baru

vaibsonly
Contributor II

Re: Pivot table....

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

Not applicable

Re: Pivot table....

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

Community Browser