Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryChin
Contributor III
Contributor III

About Pie Chart Dimension

Hi All,

The data shown below:

ProductValue
AA22
BB23
CC56
DD942
EE133
FF115
AA5525
BB52
CC452
DD21
EE1545
FF455

 

I just want to display Sum(AA),Sum(BB),Sum(CC) in a pie chart. How can I filter out the other without filter pane. The dimension is Product and measure is Value.

 

Thanks

Gary

 

Labels (1)
4 Replies
Vegar
Partner
Partner

Try it like this : Sum({<Product={'AA', 'BB', 'CC'}>} Value) 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
GaryChin
Contributor III
Contributor III
Author

Dear Vegar,

 

There only show sum AA value.

 

Thanks

Gary

Vegar
Partner
Partner

Make sure you got the  spelling of the field values correctly. It's case case sensitive and if the field is a dual then you need to refer to the string part of the dual. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
GaryChin
Contributor III
Contributor III
Author

Dear Vegar,

I solved this problem. In the measure Expression I written:

sum({<Product={'AA'}>}Value) & sum({<Product={'BB'}>}Value) & sum({<Product={'CC'}>}Value) 

The pie chart only display that three product.

 

Thanks

Gary