topic Re: Filter For Status in QlikView

Filter For Status

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

Hi All,

I m trying to achieve creating filter or list box or Calculated dim in my app to filter data like following Cse:

PR without PO

PR without PO and with IO

PR with PO

PR with PO and IO

Invoices without PR

Invoices without PR- with IO

For reference check attached app

sunny_talwar — Wed, 25 Jan 2017 09:54:12 GMT

It might not be a great idea to do this on the front end. Can you rather join the tables and do it in the script?

subbareddykm — Wed, 25 Jan 2017 09:58:14 GMT

If i i got chance in back end , then i have some idea .

No problem Sunny give solution for front end . I can manage.

Because i have join so many table now , if we try it in back end now

subbareddykm — Wed, 25 Jan 2017 10:21:21 GMT

Please guide ,How to create in front end Sunny.

sunny_talwar — Wed, 25 Jan 2017 10:25:14 GMT

Did it for 2... you can extend the logic

=If(Len(Trim(PR)) > 0 and Len(Trim(IO)) > 0 and Len(Trim(PO)) = 0, 'PR Without PO and With IO',

If(Len(Trim(PR)) > 0 and Len(Trim(PO)) = 0, 'PR Without PO',

))