topic Re: Create a list box or filter with only 2 options in QlikView

Create a list box or filter with only 2 options

dialika_bantog — Thu, 28 Feb 2019 12:38:45 GMT

Hi!

I wanted to create a list or app-wide filter with only two options. The options will be All and exclude 0 or null on the field. How will I be able to do that?

Cheers!

Dialika

Re: Create a list box or filter with only 2 options

MindaugasBacius — Thu, 28 Feb 2019 14:48:04 GMT

I guess that impossible.

If you wish you can create this option for chosen dimensions:

1. Data that is not 0 or null

2.Data that is 0 or null

,If(Field = 0 or Len(Trim(Field)) = 0, 1, 0) as Flag

After that you will have to create two buttons:

1. All Data - it means it activates all Flag field's both values 1 and 0.

2.Exluded 0 - it mean it have to activate Flag = 1

Re: Create a list box or filter with only 2 options

dialika_bantog — Fri, 01 Mar 2019 03:57:49 GMT

Got it. Thanks heaps!