topic Re: custom list box in QlikView

custom list box

Wed, 11 Dec 2013 09:45:09 GMT

I have added in the custom expression below in order to only bring into the list box the Drivers that are actually used within the data (ie there are around 30k set up but only 3k with data on).

The formula below appears to work as a much reduced list of drivers are brought through into the list box.

However the issue i have is that when one is selected the rest disappear completely out of the list box, how can i edit my formula/settings so that the other options stay in the box and appear greyed out as per the standard formats of a list box?

Aggr(If(
(
fabs(ROUND(Sum(COST)))+fabs(round(sum(revenue)))
) <>0, [Driver Type]),[Driver Type]
)

Re: custom list box

Wed, 11 Dec 2013 09:52:07 GMT

Hi Jono

did you untick "mask excluded values" in tab General ?

best regards

chris

Re: custom list box

Wed, 11 Dec 2013 10:01:34 GMT

No that box isnt ticked

Jon

Re: custom list box

Wed, 11 Dec 2013 10:24:16 GMT

Hi,

If you use Aggr then the unselected values will be disappear. So, instead of using Aggr, you just use IF condition.