Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem with trellis pie charts

Hi!

I'm creating a trellis chart for the first time.

I want a pie chart "multiplied" with the number of product categories I have so that's an obvious dimension. But then I want to calculate my sales on basis of Product Type (that can be either "1" or "0") and have a slice representing each Product Type.

So what I do is the following:


DIMENSIONS

Category

ProductType

EXPRESSION

=sum(Sales)

But, when enabling Trellis and "Second Dimension" I get this weird result:

trellis.png

0,1 = ProductType

00,1A,1E,etc... = Category

How do I get the result I want?

Thanks

Tags (1)
2 Replies
Employee
Employee

Re: Problem with trellis pie charts

Make sure "Enable Secondary Trellis Dimension" is unchecked.

whiteline
Honored Contributor II

Re: Problem with trellis pie charts

If I understand correctly you sould change the order of you dimensions and uncheck Secondary trllis dimension.

Community Browser