topic Re: Filtered values in a straight table in QlikView

Filtered values in a straight table

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

Hi Everyone,

I was wondering if someone could help me understand how to create a simple straight table that shows only a specific value. I am new to QlikView and looking to learn how to use expressions properly to filter information shown in a particular table or graph.

For example, I am trying to create a separate straight table that only contains the blank values highlighted below:

Most of my results end up looking like this:

Any help would be greatly appreciated.

Kind regards,

Martin

Re: Filtered values in a straight table

MarcoWedel — Sun, 08 Apr 2018 21:28:17 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: Filtered values in a straight table

Anonymous — Mon, 09 Apr 2018 02:32:52 GMT

Hi Marco,

Thank you for the quick reply. When I try this approach I get the following:

Any other suggestions, or something I may be doing wrong? Thank you for your help!

Regards,

Martin

Re: Filtered values in a straight table

Nagaraju_KCS — Mon, 09 Apr 2018 02:43:03 GMT

one solution..

Exp =NullCount(Clearance/License Date)

and Hide this expression in presentation tab

Re: Filtered values in a straight table

sasiparupudi1 — Mon, 09 Apr 2018 11:32:08 GMT

Use the expression

Len(Trim([Clearance/License Date]))=0

Re: Filtered values in a straight table

Anonymous — Mon, 09 Apr 2018 13:48:46 GMT

Hi Raju,

I still get the following with this expression:

Re: Filtered values in a straight table

Anonymous — Mon, 09 Apr 2018 13:49:44 GMT

Hi Sasidhar,

I still get the following with the expression you suggested:

Re: Filtered values in a straight table

sasiparupudi1 — Mon, 09 Apr 2018 19:22:17 GMT

Please post a sample app here

Re: Filtered values in a straight table

Nagaraju_KCS — Tue, 10 Apr 2018 03:38:38 GMT

PFA,

Which we have provided, All expressions should work.

=ISNUL(Date)

=NULLCOUNT(Date)

=LEN(TRIM(DATE))=0