topic Re: filter in QlikView

filter

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to create a field or a front end expression to filter rows in Status field.

The user should have 2 values to choose- Top, All.

When All is selected, show all products. If Top is selected show only products with status Yes.

Data:

LOAD * INLINE [

Product, Status

A, YES

B, YES

C, NO

D, NO

];

I created this filter but it is not working

if(Status = 'YES' or Status = 'NO','All',

if(Status = 'YES','Top'))

Please help.

Re: filter

arvind_patil — Wed, 11 Oct 2017 11:27:35 GMT

Hi Suraj,

You need to create only top filter why you require all

If top is not selected means its by default all.

If(Status = 'YES','Top') as TOP.

Thanks,

Arvind patil

Re: filter

Clever_Anjos — Wed, 11 Oct 2017 11:32:19 GMT

Please check if fits your needs

Re: filter

avinashelite — Wed, 11 Oct 2017 12:13:58 GMT

Try like this

Data:

LOAD * INLINE [

Product, Status

A, YES

B, YES

C, NO

D, NO

];

LOAD * INLINE

[

Status,Filter

YES,TOP

YES,ALL

NO,ALL

];

Now use the filter column in the front end to get the desired results

Re: filter

surajap123 — Thu, 12 Oct 2017 20:28:58 GMT

Thanks everyone for various solutions.