Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show only no value of record?

Hi guys,
Not sure how to say about this, or someone already asking for this.
I tried to search on this forum it seem no one has question this before.
Does anyone knew how to show/present no value of record from database?
I have problem to show/present item which doesn't have record.
Entry call "Item No_" but when I just LOAD "Item No_" without anything it will showed up all entire record.
But if i LOAD "Item No_" and with others or let say "Description" it will showed Item No will Description.
And the problem is, we need only Item No which doesn't have record on Descritpion.

The reason behind this because we have hundred thousand record for item no but we doesn't know which one have entry with others or not.

What is the correct formula to do it?

0 Replies