topic Re: List Box problem in QlikView

List Box problem

Fri, 10 Apr 2015 10:59:12 GMT

Hi all

Any help on this would be appreciated.

I have a straight table, which has various filters applied so that only certain results (buckets in my case) are displayed. I also have a dimension limit applied so that only results less than -1,000 are shown.

When I create a list box to allow a filter between different buckets however, the list box shows 'white' options for buckets which are empty in the straight table. I assume it's allowing the user to select a bucket which either a) is greater than -1k, or b) filtered out using the set analysis I prepared in the straight table.

Current list box expression:

Straight table (showing only Other and S7 Performance)

Current List box (allowing selections for all buckets)

Thanks

Re: List Box problem

ankitaag — Fri, 10 Apr 2015 14:31:39 GMT

Can you please attach your qvw file?

Re: List Box problem

Or — Mon, 13 Apr 2015 08:23:11 GMT

Graeme,

From QlikView's point of logic, there's no reason for the buckets to gray out because they are still possible in the data model - they're just not displayed in this specific chart because of a dimension limit (which does not make any selections in the data model). If you want them to be displayed but grayed out, you're going to have to do something along the lines of using a trigger to select all of the possible values that composed buckets displaying in the chart.

Re: List Box problem

mrossoit — Mon, 13 Apr 2015 08:35:50 GMT

You should define list box expression using in set analysis the same logic you applied in dimension limit.

Upload your qvw as Anikita asked.

Regards

Re: List Box problem

Mon, 13 Apr 2015 08:50:40 GMT

Please see attached example

Thanks

Re: List Box problem

Mon, 13 Apr 2015 08:57:53 GMT

Try to apply the filters in the scripting itself

Re: List Box problem

mrossoit — Mon, 13 Apr 2015 09:00:24 GMT

When I try to open it, my QlikView client tells me "Access denied"