Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@SonPhanHumanIT The best option i can think to adding calculated dimension or expressions with Len().
Ex, If(Len(FieldA)>0, FieldA)