Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 🙂