topic Re: Problem with a formula in QlikView

Problem with a formula

pgalvezt — Thu, 23 Jan 2014 20:09:46 GMT

Hi,

I have the follow Formula:

sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor (Works Fine)

But In the last row QlikView shows a negative value. I need to hide that row. Anybody knows how to do that.

Or I need to delete the row but I need to show all total.

Thanks!

Re: Problem with a formula

Anonymous — Thu, 23 Jan 2014 20:11:54 GMT

= if ( sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor < 0 , null() , sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor )

And don't forget to suppress nulls.

Re: Problem with a formula

jerem1234 — Thu, 23 Jan 2014 20:16:34 GMT

Are you using dimension limits? I translated Otros using Google to Others. If you are using dimension limits, then go to dimension limits tab and un-check "Show Others" near the bottom.

Re: Problem with a formula

pgalvezt — Thu, 23 Jan 2014 20:18:41 GMT

Thank you for your reply but is not what I want. I want to Hide the negative row but I need to show all total.

For example I have this

Sales

-1

------

I need to show the total 5 and hide the -1. If I put delete value nulls the total gives 6.

Re: Re: Problem with a formula

Anonymous — Thu, 23 Jan 2014 21:02:16 GMT

Is the attached what you are after ?

See reply from jerem1234 for explanation.

Best Regards, Bill