Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to remove nul value row from my QS Table ?

Hi All

My Table have 2 column PY and CY , with the help from manish .

PY it have 5 row have value.

May i know how to remove all row which are null value ?

Remark :- In QV simialr table does not have null value. this only happen in QS.

Paul

1 Solution

Accepted Solutions
Not applicable

Re: How to remove nul value row from my QS Table ?

Hi Paul,

Please check the attached file again on the last sheet. The target is to replace Null with 0 so the Show Zero untick works. I've changed the expression for UP SALES CY, Variances.

Let me know if this is what you're looking for.

5 Replies
paulyeo11
Valued Contributor II

Re: How to remove nul value row from my QS Table ?

My QVF

Not applicable

Re: How to remove nul value row from my QS Table ?

Hi Paul,

Is that the REMOVE ROW WITH NULL tab that you want us to look at?

If Yes then please look at the attached file, i remove Company Pay expression you used and just add Company Pay as dimension.

Also the expression to calculate sum, i've replace Null() & '' to 0, so the Show Zero works

if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, (if(Sum(curren)<>0,Sum(curren),0)),0)

Hope it makes sense to you

paulyeo11
Valued Contributor II

Re: How to remove nul value row from my QS Table ?

Hi Nhu

Thank you for your help. I am sorry I am

Refer to last sheet , sheet name = My Nee sheet (1)

Paul

Sent from my iPhone

Not applicable

Re: How to remove nul value row from my QS Table ?

Hi Paul,

Please check the attached file again on the last sheet. The target is to replace Null with 0 so the Show Zero untick works. I've changed the expression for UP SALES CY, Variances.

Let me know if this is what you're looking for.

paulyeo11
Valued Contributor II

Re: How to remove nul value row from my QS Table ?

Hi Nhu

wow you make a lot of changes. Thank you very much. Now okay

Paul