Treemap creation merging multiple headers and count certain numbers

[yadavsaket1]

Hi everyone,

I came to an issue regarding creating a treemap.

I need to group the headers and sub-calculations.In the attached excel file, I have shown the raw data to the sorted data to Qlik Sense visualisation. and also mentioned where the help is required.

Is it possible in qlik sense?

[Channa · Accepted solution]

you dont have any direct dimensions??

this CrossTable takes one value default so add one Column as answers before 

CrossTable(Goal, Priority)
LOAD

Answers ,
A1,
A2,
A3,
B1,
B2,
B3,
C1,
C2
FROM [lib://QlikCommunity/Closstable.xlsx]
(ooxml, embedded labels, table is Sheet1);

on top of this table try to calculate % below measure

first:count({<Priority={1,2}>} Priority)

second:count( total {<Priority={1,2}>} Priority)

it will work for u 

Attach will help you you have the expected results see attach