topic Re: Need logic help in QlikView

Need logic help

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

I attached file,

I want to show only the sum of Positive numbers. and in table all number should be present (Positive & Negative).

Thanks,

Lalit kumar

hemachandran — Thu, 13 Oct 2016 06:50:59 GMT

Hi lalit,

try this expression, it will show only positive values..

=if(sum(Amount)>=0,sum(Amount))

fashid — Thu, 13 Oct 2016 06:59:08 GMT

hi,

Please check the attached QVW.

Please mark the question as answered if it meets ur requirement .

nagarjuna_kotha — Thu, 13 Oct 2016 07:21:08 GMT

Try this.

Use this expression:

=sum(if(Amount>0,Amount))

I hope this might hekps you

-Nagarjun

Anil_Babu_Samineni — Thu, 13 Oct 2016 07:28:43 GMT

I don't have license, Can you please check for this on your application whether this is working or not

=sum({<Amount = {'>0'}>} Amount * 1)

Frank_Hartmann — Thu, 13 Oct 2016 07:59:27 GMT

try like this:

=if(sum(Amount)>0,sum(Amount),text(sum(Amount)))

harishkumarg — Thu, 13 Oct 2016 08:28:02 GMT

Please find the attached app.

Expression:

if( Dimensionality()=0 , sum({<Amount={">0"}>}Amount) , Sum(Amount) )

Few changes in the Presentation Tab,

Hope this helps!

Regards

Harish

sunny_talwar — Thu, 13 Oct 2016 09:50:44 GMT

If in case you have more than one amount value per Prod and you want to check if the Sum(Amount) is greater than 0, then try this

=If(Dimensionality() = 0,Sum({<Prod = {"=Sum(Amount) > 0"}>}Amount), Sum(Amount))