Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

pie chart with calculation dimension

Hello , I have a table with two columns IdProduct and price

How can i show a pie chart that count the percentage of the product with price < 30, 

the percentage of the product with price >30 and < 100,

the percentage of the product with price > 100

 

Thank you for your helps

 

Tags (2)
Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: pie chart with calculation dimension

Create pie chart with

 

Dimension : Valuelist('Price<30','Price>30<100','Price>100')

Expression:

Pick(match(Valuelist('Price<30','Price>30<100','Price>100'),'Price<30','Price>30<100','Price>100'),

Count({<Product ={"=Sum(Price)/Sum(Total Price)<0.3"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>0.3 and Sum(Price)/Sum(Total Price)<1"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>1"}>}distinct Product))

 

View solution in original post

1 Reply
Highlighted

Re: pie chart with calculation dimension

Create pie chart with

 

Dimension : Valuelist('Price<30','Price>30<100','Price>100')

Expression:

Pick(match(Valuelist('Price<30','Price>30<100','Price>100'),'Price<30','Price>30<100','Price>100'),

Count({<Product ={"=Sum(Price)/Sum(Total Price)<0.3"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>0.3 and Sum(Price)/Sum(Total Price)<1"}>}distinct Product),

Count({<Product ={"=Sum(Price)/Sum(Total Price)>1"}>}distinct Product))

 

View solution in original post