How to remove nul value row from my QS Table ?

[paulyeo11]

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

[paulyeo11]

My QVF

[#3]

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]

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

[#5 · Accepted solution]

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]

Hi Nhu

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

Paul