Custom formula in list box

Wed, 04 Dec 2013 09:40:16 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 formula in list box

jonathandienst — Wed, 04 Dec 2013 09:51:27 GMT

Try

=Aggr(If(

(fabs(Round(Sum({1} COST)))+fabs(Round(Sum({1} revenue)))) <> 0,

[Driver Type]

)

,[Driver Type])

HTH

Jonathan

Re: Custom formula in list box

ljackson — Wed, 04 Dec 2013 10:12:07 GMT

In the presentation tab, ensure that suppress zero values is unchecked.

topic Re: Custom formula in list box in QlikView

Custom formula in list box

Re: Custom formula in list box

Re: Custom formula in list box