topic Re: Getting two concatenated values on pie chart in QlikView

Getting two concatenated values on pie chart

gizzel123 — Mon, 24 Nov 2014 11:43:34 GMT

Hi All,

I want to show a pie chart , which shows count and total percentage.

right now I can see the % only .

Count ({$<[Status]={done}>}Status)/count(Status)

So I want to see values like [Count. %] in pie .

Is there any way of doing that.

Thanks in advance.

Re: Getting two concatenated values on pie chart

morganaaron — Mon, 24 Nov 2014 11:55:23 GMT

Add the count expression as a second expression and select values on data points, it should ignore the actual expression but append the values underneath your current values.

Re: Getting two concatenated values on pie chart

PrashantSangle — Mon, 24 Nov 2014 12:03:32 GMT

Hi,

Use Text in chart from Presentation tab->

write your expression to count % and count in that

Try like

='[ Count : '& count(status)&' , ' &Count ({$<[Status]={done}>}Status)/count(Status) & '%'

Regards

Re: Getting two concatenated values on pie chart

gizzel123 — Mon, 24 Nov 2014 12:50:35 GMT

no guys..it isnt working.

plus the "invisible" option is diaabled in here.

Re: Getting two concatenated values on pie chart

morganaaron — Mon, 24 Nov 2014 13:31:39 GMT

Can you post the .qvw for me to have a look at?