creating a drill down data using in Qliksense data load editor

[Qlikuser09]

I had a pivot table kind of data. i did a cross table and now I have a table with three rows like this.

Sample data

Company code	Attributed fields	Count
AA	Manager	2
AA	CIO	1
AA	IT Staff	1
AA	Dev Staff	1
AA	Management Total	3
AA	Staff Total	2
AB	Manager	5
AB	CIO	2
AB	IT Staff	3
AB	Dev Staff	2
AB	Management Total	7
AB	Staff Total	5

Interpretation of the data

Management total - (Manager + CIO)

Staff Total(IT Staff+Dev Staff).

I have to make the tables function well with the front end, such that, if I select the management total, the other chart should display the details with the Manager and CIO. 

Any ideas/suggestions on how to separate the data fields .

[abhijitnalekar]

Can you share sample data? I can provide you the QVF file with the solution.  

[Qlikuser09]

Sample Data:

Company code	Attributed fields	Count
AA	Manager	2
AA	CIO	1
AA	IT Staff	1
AA	Dev Staff	1
AA	Management Total	3
AA	Staff Total	2
AB	Manager	5
AB	CIO	2
AB	IT Staff	3
AB	Dev Staff	2
AB	Management Total	7
AB	Staff Total	5

[abhijitnalekar · Accepted solution]

Hi @Qlikuser09 ,

Please find attached QVF .

[Qlikuser09]

thanks, @abhijitnalekar , thus actually worked, however, I don't want to create a new field called Manager and staff, since we already have an existing management total and staff total in the table itself. is it possible that I list the fields manager, CIO under the already existing management total and IT staff, Dev staff under the already existing staff total field without breaking the logic? 

[abhijitnalekar]

Hi @Qlikuser09 ,

Change the logic in the script as below.

if(WildMatch([Attributed fields],'Manager','CIO')>=1,'Management',
if(WildMatch([Attributed fields],'Staff*')>=1,
'Staff')) as newDim,

and uncheck the checkbox of Include null values of Hierarchy