topic Re: Trouble With Trellis in App Development

Trouble With Trellis

Ericga — Tue, 30 Nov 2021 18:17:33 GMT

I am using the Qlik Visualization Bundle Trellis and want to create two different Trellises and have each only show specific data based on Set Analysis. In my example the top trellis is for the East Region and the bottom is for the West Region. Each region trellis should only show divisions within that region. But each trellis includes divisions not in that region with the message "The Chart is not displayed because it contains only negative or zero values". i would expect the set analysis in the Master Visualization to suppress those divisions. is it possible to suppress those out of the trellis? I have attached an example qvf.

Thanks for your help

Re: Trouble With Trellis

brunobertels — Thu, 08 Jul 2021 09:32:19 GMT

Suppress the $(vDimSet) of your expression in your master visualizations

if(vToggle = 1, NUM(Count({$<[Region]={"East"}$(vDimSet)>} Order),'#,##0'),NUM(Sum({$<[Region]={"East"}$(vDimSet)>} Value),'$#,##0'))

and it should work fine :

Re: Trouble With Trellis

Ericga — Wed, 14 Jul 2021 19:56:00 GMT

Thanks for your reply Bruno. That does remove the messages but it does not solve the main issue. That being each trellis still shows dimensions that are not a part of the set analysis defined in the Master Visualizations Pie Charts. In the example, the East trellis should only show the four divisions that belong to it (Assembly, Engineering, Manufacturing and Testing) and the West trellis should only show Accounting, HR, IT and Safety. Instead each Trellis shows all 8 divisions.

Why are the Master Visualizations ignoring the Set Analysis that should only select out each regions divisions?

Thanks

Re: Trouble With Trellis

brunobertels — Thu, 15 Jul 2021 15:46:51 GMT

unfortunately , i did not find a solution

Sorry