Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

percentage in pie chart and remove prefix in bar chart

Hi All

1) Please assist I need omit CBU_BY in my bar graph how do I do that.

2) I need to display percentage of this number in my pie chart please help

16 Replies
mandilicious
Creator II
Creator II
Author

Hi Arvind654

I am not using any dimension please see my expression(s)  for pie chart

sum(Detractor, Neutral and Promoter)

Thanks

mandilicious
Creator II
Creator II
Author

Hi Rumpam

What do you mean by below am confused elaborate please.

Sum(yourFIeld)/Sum(TOTAL yourfield)

Thanks

MK9885
Master II
Master II

You're using sum(Detractor, Neutral and Promoter) as your expression?

Or it was just an example?

To get different % I'd prefer making a single expression but not 3 different expressions.

I do not know if there is a better way to do it.

But can you actually give your expression, not a metaphor example.

Not applicable

Hi Manti,

Could you please look into it.

I have tried the basic example with data.if you want to show the percentage then in number tab click on show in percent % and in the expression tab you can check the values on data points also mark the relative option.

pie2.JPG

thanks,

YJ

Not applicable

Befor applying to the Replace function to Claculated dimensionPie22.JPG

Apply Conditon :  =Replace(Skill,'Sk_','')  in the calculated dimension in the dimension tab.

thanks,

YJ

mandilicious
Creator II
Creator II
Author

Hi Yogesh

Thank you very much for your respond

I  get below when I do as you say.

below is my expressions tab

Please attached your solution.

Not applicable

Hi Manti,

I have used below sample example,

pie1111.JPG

Dimension: Skill

Expression: Sum of Val