Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Creator II
Creator II

Need logic help

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

1 Solution

Accepted Solutions
sunny_talwar

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))


Capture.PNG

View solution in original post

7 Replies
hemachandran
Partner
Partner

Hi lalit,

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

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

nadeemsmarty
Specialist
Specialist

hi,

Please check the attached QVW.

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

comm image.png !

nagarjuna_kotha
Partner
Partner

Try this.

Use this expression:

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

I hope this might hekps you

-Nagarjun

Anil_Babu_Samineni

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Frank_Hartmann
Master II
Master II

try like this:

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



harishkumarg
Creator III
Creator III

Hi

Please find the attached app.

Expression:

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


Few changes in the Presentation Tab,

Capture11.PNG



Hope this helps!


Regards

Harish

sunny_talwar

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))


Capture.PNG

View solution in original post