Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bkn
New 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
vishsaggi
Esteemed Contributor III

Re: SUM the value in text Object

May be try this in your text box

= Max(Aggr(Sum(YourTotalfield), CODE))
bkn
New Contributor II

Re: SUM the value in text Object

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.

vishsaggi
Esteemed Contributor III

Re: SUM the value in text Object

Try this in your textobject

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

Re: SUM the value in text Object

Appreciated. It works. 

 

Thanks.

vishsaggi
Esteemed Contributor III

Re: SUM the value in text Object

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