help with showing percentage in a pie chart...

[hopkinsc]

Hi, i am learning how to use the different types of charts available in QLIKVIEW.

I would like to know how to show the percentage of the following data..

I have a field RETAIL GROUP which has the following included in it:

INDEPENDENTS

OWN STORES

NAAFI

next i have a field named SALES QUANTITY which will have lots of different sales quantities for selected dates.

I want to show in a pie chart, the percentage of sales made by INDEPENDENTS, OWN STORES and NAAFI stores.

I'm sure it is quite easy to do but as i am still learning i would appreciate the help 🙂

[#2 · Accepted solution]

Hi

To show the value as a percentage, on the expressions tab, check the box marked "Relative" and the value should be shown as a percentage.

By the way...... That's the first time since I was a child that I've heard of NAAFI, are they still part of the armed forces?

[shumailh]

See the attached file, I hope it will surve your requirement.

Regards,
Shumail

[hopkinsc]

Well i am from the UK, there is no such thing as naffi here anymore, they have been bought out by a number of retail groups, but the new retail groups are still part of the armed forces, but i believe they still operate in Europe. The uk NAAFI's operate as SPAR stores. 🙂

Oh, and i work for SPAR. 🙂

[hopkinsc]

Oh, and thanks for your help. that worked fine.:)

[brenner_martina]

Hi,

you can show the data also in this way!

[brenner_martina]

Hi,

you can also show the data in this way: