topic Cyclical Group in QlikView

Cyclical Group

Tue, 10 Mar 2015 12:29:57 GMT

I have a cyclical group set up which is used accross different tabs of my report.

There are several fields in this group, however for certain objects I want to exclude one.

Is it possible to say have a master group of say 10 dimensions then dynamically exlude individual dimensions on different graphs rather than say setting up 10 different cyclical groups?

Thanks

Re: Cyclical Group

Gysbert_Wassenaar — Tue, 10 Mar 2015 19:45:54 GMT

You will need 10 different groups if you wish to use groups.

Perhaps an easier solution is to use a table with field names and use that to select the dimension for the chart(s). See this blog post: Customizable Straight Table. A listbox using such a table with field names can be easily modified to exclude a specific value using an expression like =if(MyField <> 'ExcludedValueHere',MyField).