Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The test application is attached.
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.
Hi
I have exactly same problem and am interested to know the solution.
Thanks
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 ?
Hello,
The attached link should provide some guidance on your issue.
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
Is this problem resolved ?
It doesn't work with 2 dimensions on my May 2021 Trellis
On my side it works if i remove the dollar sign ($) from the set analysis. I dont know why but it works..