Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
SonPhanHumanIT
Contributor III
Contributor III

Delete Null or 0 Rows

Dear Qlik experts,

I'm facing a challenge in Qlik Sense, specifically in a pivot table where the measure is represented as rows and dimensions are arranged below. How can I delete rows with null values or zeros? 

SonPhanHumanIT_0-1706622465577.png

SonPhanHumanIT_1-1706622487795.png

Load * Inline [
ID, FieldA, FieldB
1, 3, 5
2, 4,
3, ,5

];

Thank you in advance for your assistance!

 

Best regards

Labels (1)
1 Reply
Anil_Babu_Samineni

@SonPhanHumanIT The best option i can think to adding calculated dimension or expressions with Len().

Ex, If(Len(FieldA)>0, FieldA)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful