topic Re: Show single field values in hierarchy in QlikView

Show single field values in hierarchy

suren946 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one table with all Region,Country,State and values as below

Region	Value
APAC	200
APAC	200
Europe	300
India	100
Pak	100
England	300

And I want to show these in hierarchy as below in pivot table with expand and collapse, could someone let me know to sort this

APAC			200
	India		100
		Andhra	50
		Telangana	50
	Pak		100
Europe			300
	England		300

Re: Show single field values in hierarchy

miskinmaz — Tue, 17 Jul 2018 04:46:06 GMT

Hi,

Assuming that you already have the data of hierarchy, use pivot table as chart type.

Re: Show single field values in hierarchy

suren946 — Tue, 17 Jul 2018 05:01:14 GMT

Hi,

As shown in first table above,data is in single field. So just want to know how to convert this data to different levels to show in pivot as shown in second table

Re: Show single field values in hierarchy

miskinmaz — Tue, 17 Jul 2018 05:12:31 GMT

Hi,

Do you have a field to differentiate the country, region,state. If not can you create it.

If above things not going to work then use wildmatch functions to create this field in backend like...

if(wildmatch(Region,'India','Pak',......) ,Region) as Country

if(wildmatch(Region,'Europe',......) ,Region) as Field2

..etc

Re: Show single field values in hierarchy

suren946 — Tue, 17 Jul 2018 06:37:35 GMT

Hi Miskin,

Thank you for the reply.

Let me put my requirement in below manner.

Let all values (APAC,Europe,India,Pak..) in one column in pivot table but initially only APAC,Europe should be shown. But when I click on a button I should show the India,Pak , England and click on another button should hide India,Pak , England values

Re: Show single field values in hierarchy

jyothish8807 — Tue, 17 Jul 2018 07:36:10 GMT

Hi Surendra,

Please refer the sample attached.

Br,

Re: Show single field values in hierarchy

suren946 — Tue, 17 Jul 2018 07:44:28 GMT

HI Jyothish,

My requirement is to show the all values( (APAC,Europe,India,Pak..) in single column and

a. Initially show only APAC and Europe

b. Place button to show/hide the (India,Pak,England ) row values

Please let me know if this is possible or not in pivot table

Re: Show single field values in hierarchy

jyothish8807 — Tue, 17 Jul 2018 12:14:25 GMT

May be this:

Give it a try.

Br,