topic Re: Trellis and Pie Chart not working in App Development

Trellis and Pie Chart not working

patricesalem — Wed, 12 Feb 2020 17:12:46 GMT

I'm on Qlik Sense Server Sept 2019 patch 1.

After trying to get my usual pie charts into a trellis chart with no luck, I've tried to get them working together with a very simple pie chart.

In this pie chart, I have one dimension "Product Family" - 8 different possibilities and "include null value" is unticked.

The measeure is very simple : =sum(NET_POSTE)

In my trellis, I have one dimension : =[D_SALES.autoCalendar.Year] and "include null value" is unticked.

Here is the result

It there a bug in the server version ? Should I upgrade it or am I doing something wrong.

Here is the pie2 by itself:

And the trellis options:

Thanks for your help

Re: Trellis and Pie Chart not working

kaushiknsolanki — Wed, 12 Feb 2020 17:16:15 GMT

Hi,

Can you share the sample app, which shows your problem.

Re: Trellis and Pie Chart not working

patricesalem — Thu, 13 Feb 2020 06:44:04 GMT

Hello

Unfortunatelly, I can't as my qvf contains all company sales data (it also has section access...)

Can you manage yourself to get Pie Chart and Trellis working together on a Qlik Sense server version sept 2019 patch 1 ?

thanks

Re: Trellis and Pie Chart not working

patricesalem — Thu, 13 Feb 2020 15:51:52 GMT

Definitely something to do with my data...

I have loaded a simple qvf containing my sales table (without any joint) and the trellis works perfect.

How can I find out where the data problem comes from ? something to do with null values ?

thanks

Re: Trellis and Pie Chart not working

patricesalem — Thu, 13 Feb 2020 15:58:04 GMT

Found the issue !

Using the master calendar value, the trellis was not working. I have finally used the year(date_of_sales) function in the dimensions definition and it worked like a charm !

Re: Trellis and Pie Chart not working

patricesalem — Thu, 13 Feb 2020 17:18:43 GMT

Sorry but there is another issue. As soon as I add a "not simple" sum in the pie measure such as :

=sum({<[HIERARCHIE]-={"PIECE*"},[Family code]-={'60'}>}QTE_POSTE)

then the trellis does not work anymore.

How can I get round the problem ?

thanks