Filtered values in a straight table

[Anonymous]

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

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco

[Anonymous]

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

[qv_testing]

one solution..

Exp =NullCount(Clearance/License Date)

and Hide this expression in presentation tab

[sasiparupudi1]

Use the expression

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

[Anonymous]

Hi Raju,

I still get the following with this expression:

[Anonymous]

Hi Sasidhar,

I still get the following with the expression you suggested:

[sasiparupudi1]

Please post a sample app here

[qv_testing]

PFA,

Which we have provided, All expressions should work.

=ISNUL(Date)

=NULLCOUNT(Date)

=LEN(TRIM(DATE))=0