Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

SUM the value in text Object

QlikForum.PNG

CODE is the Dimension and TOTAL is expression. I wan to get only the Total value which is great than $50. I want to get that $75 value in the Text Object.

Thanks in Advance.

 

5 Replies
Highlighted
Champion III
Champion III

May be try this in your text box

= Max(Aggr(Sum(YourTotalfield), CODE))
Highlighted
Contributor II
Contributor II

QlikForum1.PNG

Data is dynamic, i need to get the value of Total which is greater than 50  in text object. for e.g. 266 from this image.

Thanks in Advance.

Highlighted
Champion III
Champion III

Try this in your textobject

= Sum({<Totals = {"=Totals>=50"}>}Totals)
Highlighted
Contributor II
Contributor II

Appreciated. It works. 

 

Thanks.

Highlighted
Champion III
Champion III

Oh great. Got it now. Please closed the thread marking correct helpful responses.