
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trellis and Pie Chart not working
Hi
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you share the sample app, which shows your problem.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
