topic Re: HELP WITH CHART in QlikView

HELP WITH CHART

Fri, 07 Feb 2014 07:30:42 GMT

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

Re: HELP WITH CHART

hic — Fri, 07 Feb 2014 08:43:10 GMT

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

Re: HELP WITH CHART

Fri, 07 Feb 2014 08:43:12 GMT

Can you attach sample data or app for the same?

Re: HELP WITH CHART

Fri, 07 Feb 2014 12:59:09 GMT

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

Regards

Re: HELP WITH CHART

sunilkumarqv — Fri, 07 Feb 2014 13:05:10 GMT

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

Re: HELP WITH CHART

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:48:44 GMT

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.