Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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?
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?
See the attached file, I hope it will surve your requirement.
Regards,
Shumail
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. 🙂
Oh, and thanks for your help. that worked fine.:)
Hi,
you can show the data also in this way!
Hi,
you can also show the data in this way: