topic Re: SUM the value in text Object in QlikView

SUM the value in text Object

bkn — Sat, 16 Nov 2024 04:23:57 GMT

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.

Re: SUM the value in text Object

vishsaggi — Tue, 19 Feb 2019 22:29:30 GMT

May be try this in your text box

= Max(Aggr(Sum(YourTotalfield), CODE))

Re: SUM the value in text Object

bkn — Tue, 19 Feb 2019 22:46:15 GMT

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.

Re: SUM the value in text Object

vishsaggi — Wed, 20 Feb 2019 13:31:59 GMT

Try this in your textobject

= Sum({<Totals = {"=Totals>=50"}>}Totals)

Re: SUM the value in text Object

bkn — Wed, 20 Feb 2019 15:26:07 GMT

Appreciated. It works.

Thanks.

Re: SUM the value in text Object

vishsaggi — Wed, 20 Feb 2019 16:21:39 GMT

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