Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Miguel_Angel_Baeyens

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
Author

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
Author

Hi,

can anyone have idea about this...!

thanks in advance,

regards,

baru

Anonymous
Not applicable
Author

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
Author

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