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

remove the null values or - from the table box in qliksense

I have table box like 

SID,   S.Marks,   S.Pass

1,        220,          PASS

2,       550,           -

3,       450,         PASS

4,       100,         FAIL

5,       300,        PASS

6,      420,         -

7,      372,        PASS

 

I want output like....

SID,   S.Marks,   S.Pass

1,        220,          PASS

3,       450,         PASS

4,       100,         FAIL

5,       300,        PASS

7,      372,        PASS

 

 

Labels (1)
1 Reply
PrashantSangle

select chart > property > add ons > untick "include 0 values"
and
property > select "s.pass" dimension > untick "include null values"
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂