Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
one solution could be:
hope this helps
regards
Marco
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
one solution..
Exp =NullCount(Clearance/License Date)
and Hide this expression in presentation tab
Use the expression
Len(Trim([Clearance/License Date]))=0
Hi Raju,
I still get the following with this expression:
Hi Sasidhar,
I still get the following with the expression you suggested:
Please post a sample app here
PFA,
Which we have provided, All expressions should work.
=ISNUL(Date)
=NULLCOUNT(Date)
=LEN(TRIM(DATE))=0