topic Re: How to remove nul value row from my QS Table ? in App Development

How to remove nul value row from my QS Table ?

paulyeo11 — Wed, 13 Jul 2016 00:49:49 GMT

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

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

paulyeo11 — Wed, 13 Jul 2016 00:51:52 GMT

My QVF

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

Wed, 13 Jul 2016 01:28:05 GMT

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

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

paulyeo11 — Wed, 13 Jul 2016 02:03:20 GMT

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

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

Wed, 13 Jul 2016 02:20:13 GMT

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.

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

paulyeo11 — Wed, 13 Jul 2016 03:17:42 GMT

Hi Nhu

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

Paul