Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ritesh_143242
Contributor
Contributor

Need to calculate % in pie chart

Role level 1  Role level 2. Total

Engg               QA.                   157

Other               BA.                 34

Xyz.                   REM

 

I need If( Role level 1,'BA'),Role level 2 

And it will like 34/157

How we do? 

Please help me

 

 

 

 

 

Labels (5)
1 Reply
martinpohl
Partner - Master
Partner - Master

create a bar chart, Role level 2 as dimension and sum(Total)/sum(total Total) as expression.

Regards