Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MaLoMe
Partner - Contributor
Partner - Contributor

Trellis and Set Analysis

I try Trellis and I have a problem working with Set Analysis. With a simple Measures SUM, everything is OK (green barchart), but when I add Set Analysis (blue barchart) Trellis doesn't work. I tried Advanced mode with adding $ (vSetDim), but it didn't help either. Can anyone help?

Image_20190820_150806.png

The test application is attached.

 

Labels (1)
8 Replies
simonaubert
Partner - Specialist II
Partner - Specialist II

Given the fact that the treillis basically put a set analysis in your measure that includes every value of the dimension it's based on, I'm not that surprised. However, there is no documentation saying it shouldn't work with...

And if you have a look on the formula in the treillis, your set analysis is modified but I don't think this syntax (treillis set analys + your own set analysis) works. Maybe contact support.

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
neoiris
Contributor
Contributor

Hi  

I have exactly same problem and am interested to know the solution. 

Thanks 

Cba
Contributor
Contributor

Hello, does anybody know is this issue (Treillis does not work with Set Analysis) is meant to be corrected in a forecoming version of Qlik Sense ? 

akoretchko
Employee
Employee

Hello, 

The attached link should provide some guidance on your issue. 

 

https://support.qlik.com/articles/000086312

akoretchko
Employee
Employee

Hello,

https://support.qlik.com/articles/000086312

 

Does this link solve help solve your issue?

paulcalvet
Partner - Specialist
Partner - Specialist

Hello,

I have the november 2019 version.

It work now with this syntax : 

(Sum({$<[Event type]={'GALLERY_EXPOSURE'}, [Before/After v12 code]={1} $(vDimSet)>} [Nb users by day]))

The problem is that the Chart doesn't work if I have two dimension. The treillis chart calculate the formulas with only one dimension.

Do you have the same problem ?

Thanks

 

AlexTheTRex
Contributor II
Contributor II

Is this problem resolved ?

It doesn't work with 2 dimensions on my May 2021 Trellis

mariusbirk
Partner - Contributor III
Partner - Contributor III

On my side it works if i remove the dollar sign ($) from the set analysis. I dont know why but it works..