Discussion Board for collaboration related to QlikView App Development.
I have the following column:
As you can see there is a mixture of dates, text and NULL values in this column. I have created a button where I want to TOGGLE SELECT "Type A" to only select Non-Null values.
I have tried the follow: <>"". But this only seems to show me the dates, and does not include the TBC. Is there a formula where I can select any that isn't NULL?
Thanks for the suggestion. But that has no affect
This works perfectly. Cheers Wallo.
For one of my columns I would need it to include all NON-BLANKS except for those marked N/A? Is this do-able? I tried using an AND function but either I am not typing it right or it doesn't work.