Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suren946
Contributor III
Contributor III

Show single field values in hierarchy

Hi All,

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

   

RegionValue
APAC200
APAC200
Europe300
India100
Pak100
England300

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
Andhra50
Telangana50
Pak 100
Europe 300
England 300
7 Replies
miskinmaz
Creator III
Creator III

Hi,

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

suren946
Contributor III
Contributor III
Author

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

miskinmaz
Creator III
Creator III

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


suren946
Contributor III
Contributor III
Author

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

jyothish8807
Master II
Master II

Hi Surendra,

Please refer the sample attached.

Br,

KC

Best Regards,
KC
suren946
Contributor III
Contributor III
Author

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

jyothish8807
Master II
Master II

May be this:

Give it a try.

Br,

KC

Best Regards,
KC