Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HELP WITH CHART


I HAVE A FIELD CALL FIELD_A

IT HAS 3 VALUES:  PRODUCT1, PRODUCT2, PRODUCT3

I CREATE A TABLE. DIMENSION FIELD_A AND EXPRESSION %EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6

NOW I WANT TO CREATE A PIE CHART AND I WANT TO SEE

%EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6 IN THE PIE CHART BY PRODUCT

thanks

5 Replies
hic
Former Employee
Former Employee

You need to explain what you mean with "EXPRESSION %EVOLUTION1 ..." etc. An expression must have an aggregation with a field in it, e.g. Count( ID ) or Sum( Amount ).

HIC

Not applicable
Author

Can you attach sample data or app for the same?

Not applicable
Author

%EVOLUTION1, = SUM(EVO1) THE SAME FOR 2 TO 6.

Regards

sunilkumarqv
Specialist II
Specialist II

What you mean %EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6

Gysbert_Wassenaar

A pie chart can either have one or two dimensions with one expression. Or it can have no dimension and one or more expressions. So %evolution1 %evolution2 %evolution3 %evolution4 %evolution5 %evolution6 in the pie chart by product cannot be shown in one pie chart. You could enable the trellis option on the Dimension tab to get a pie for each product.


talk is cheap, supply exceeds demand