topic Re: Filter in QlikView

Filter

Wed, 27 Nov 2013 16:35:09 GMT

Hi guys,

I'm trying to build a graph, which has a drill down group, and I currently have a few filters that apply to it. I want the filters to only allow one value to be selected for all dimensions in the group but one. so for example, I have monthly and yearly data for a number of shops in different regions, so my drill down group is country->region-->city-->shop and for the first three I just one to see the data for one month, but for the shop I want the graph to show a few months. Trouble is, when I enable multiple selections in the months filter, the graph has too much data and looks ridiculous. Any suggestions how I can overcome this?

Thank you,

Anna

Re: Filter

albertovarela — Wed, 27 Nov 2013 16:46:27 GMT

Hello, Have you tried enabling the X-Axis scroll bar?

Re: Filter

Wed, 27 Nov 2013 16:49:04 GMT

I did, but it still looks rubbish when multiple selection is enabled at higher level of the drill down group. Thanks for trying though!

Re: Filter

albertovarela — Wed, 27 Nov 2013 16:55:33 GMT

How about Dimension Limits?

Re: Filter

Wed, 27 Nov 2013 16:58:58 GMT

that could potentially work, however, I want to apply it to 3 levels of the drill down group, and leave one out.