topic Help with Trellis Chart in App Development

Help with Trellis Chart

Nemo1 — Fri, 15 Nov 2024 21:03:17 GMT

Hello,

So I want to create a trellis chart to show the same graph many times, but in each case, should only show the information of one dimension.

I did the following but it did not work out.

1- I created a line chart with many dimensions.

2- I converted this line chart to a master visualization

3- I added a trellis chart

4- I selected the dimension that I want. I want to portray as many line charts as dimensions I have

5 - I get 12 charts, which is the numbers of dimensions i have, each of them have a different title, according to the dimensions... but the graph shown is still the same...

what am i doing wrong?

thanks

Re: Help with Trellis Chart

stevedark — Sun, 25 Feb 2024 09:43:40 GMT

Hi @Nemo1

I've just hit the same bug. The first time I've seen it, but I don't use the trellis much.

I tried adding a simpler chart, with just sum(Value) as the measure, and that worked fine.

I then returned to the chart that didn't work and saw that this had the expression coming from a variable (which I tend to always do). I copied the code from the variable into the master item directly, and it worked.

Having the expression as a Master Item worked fine, so this gives some of the advantages of using variables, without tripping up the trellis.

Hopefully this will work for you also.

Steve

Re: Help with Trellis Chart

vinieme12 — Mon, 26 Feb 2024 05:59:30 GMT

try using the Advanced mode and add either $(vDimSet) or $(vDimSetFull) in the expression of your master visualization

Also note you can't use this for calculated dimensions

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/VisualizationBundle/trellis-container.htm

Re: Help with Trellis Chart

Nemo1 — Tue, 27 Feb 2024 10:29:51 GMT

I am not understanding...

So before I set my master visualization, which was a line chart, and I used a measure that I created... that did not work, as I get the same graph many times..

Then, instead of using a measure, I just copied the formula of my measure and I paste it, still did not work..

then I created a variable, and i used the same formula that I have been using, and I selected it, but I got a message that says "The chart is not displayed because it only contains undenifed values"

I am so lost

thansk in advance,

Re: Help with Trellis Chart

Nemo1 — Tue, 27 Feb 2024 10:31:32 GMT

I did not realise that I was calling the variable wrong, i forgot to add the $(), but still, i do it, and i get alwazs the same graph

Re: Help with Trellis Chart

Nemo1 — Tue, 27 Feb 2024 10:34:22 GMT

Hello, thanks for your answer.. what do you mean with calculated dimensions?

I am using the following: if(source='StoreSales', sum(Sales)/1000)

Re: Help with Trellis Chart

stevedark — Tue, 27 Feb 2024 10:50:48 GMT

Hi @Nemo1

Can you please share what dimension you are using in the chart, what dimension you have on the master item and the measure on the master item - ideally with screenshots of each in situ.

The dimension on the trellis should be a field from the data model, and not something that is derived.

Please try with a very simple measure on the master item, e.g. sum(Sales).

I think the expression that you have would be better written as:

sum(if(source='StoreSales', Sales, 0))/1000)

This will add up all Sales where the source matches, rather than adding up all sales and then only showing them if the source is StoreSales, within the current dimension. There's an important difference in how it is worked out.

Hope that helps.

Steve

Re: Help with Trellis Chart

Nemo1 — Tue, 27 Feb 2024 15:04:55 GMT

Hello Steve,

Unfortunately I cannot share screenshots 😞

I tried with a simple measure in another dashboard and it did work.

Then I tried with your formula and it did not work.

I think that the problem is that the dimension I am using for the trellis, although it comes from the data model, it is a "mapped" dimension. Probably that is making my life complicated now?

the dimension is my dataload editor looks like this: applymap ('Map_Store', Hous) as Store

thanks for your awesome answers and your patience

Re: Help with Trellis Chart

Nemo1 — Tue, 27 Feb 2024 15:06:57 GMT

I am trying to find a work around this but it is not leading me to anything

Re: Help with Trellis Chart

stevedark — Tue, 27 Feb 2024 15:27:39 GMT

It won't be the fact that it comes from an ApplyMap. Having Null values in the results may be an issue, or if it doesn't associate with the rest of the data model nicely.

Have you checked doing a simple table with Store as a dimension and your expression as the expression?

Have you checked the data model viewer, to ensure that is as you would expect it to be? Any tables not joined to the rest of the model could certainly cause this.

Steve

Re: Help with Trellis Chart

Nemo1 — Wed, 28 Feb 2024 08:00:41 GMT

Hello Steve,

I did create simple table and the data is coming with no problem.

All the tables are correctly join.. this is a mistery!

Re: Help with Trellis Chart

stevedark — Thu, 29 Feb 2024 10:52:30 GMT

Hi @Nemo1

This is quite odd. I would try creating a trellis that does work and then keep adding things one at a time until it breaks.

It might be worth exploring @vinieme12's suggestion of using advanced mode and $(vDimSetFull).

Basically, the way this works is that it gives you set analysis that you can inject into your expression.

So, if the expression in the master item is sum(Sales) you would make it sum($(vDimSetFull)Sales).

If you already have some set analysis you will need to use one of the partial set variables, as below:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/VisualizationBundle/trellis-container.htm

Good luck!