topic Re: Conditional Expression based on List Boxes in QlikView

Conditional Expression based on List Boxes

Tue, 05 Nov 2013 20:34:17 GMT

I need some advice, I have a list box that has three values from an inline table:

100 Other

200 Purchase

300 Rental

I sum a monetary field and create a total for each of these values, so the table looks like this

Purchase Rentals Other Total

###$ ###$ ###$ ###$

If the user selects Other I only want the Other and Total columns to show, If a user selects Purchase and Rentals I want only Purchase, rental and Total columns to show but NOT other.

What happens is if the user select one of the list choices only that field shows, I can also get all of them to show when nothing is selected by using getselectedcount = 0. What I can't get is two of the fields to show. So if a user selects BOTH purchase and rentals nothing shows. Is there a way to get this to work ?

Re: Conditional Expression based on List Boxes

Carlos_Reyes — Tue, 05 Nov 2013 20:56:58 GMT

You can use SubstringCount. For instance, the conditional for the Purchase expresion would be the next:

SubstringCount( Concat ( Field, ' | '), 'Purchase')

If you want to make sure that Purchase is selected then you only have to add the GetSelectedCount function

SubstringCount( Concat ( Field, ' | '), 'Purchase') AND GetSelectedCount( Field ) >=1

Re: Conditional Expression based on List Boxes

Tue, 05 Nov 2013 21:06:30 GMT

Thank you Carlos, it worked like a charm !