Delete Null or 0 Rows

SonPhanHumanIT — Tue, 30 Jan 2024 14:02:56 GMT

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?

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

];

Thank you in advance for your assistance!

Best regards

Re: Delete Null or 0 Rows

Anil_Babu_Samineni — Tue, 30 Jan 2024 15:14:15 GMT

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

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

topic Delete Null or 0 Rows in App Development

Delete Null or 0 Rows

Re: Delete Null or 0 Rows