Displaying Value on Text Object

[#1]

Hi Qlikview Community,

I need to display the total of my Current Tax and Penalty on a Text Object but I don't know how.

I also attached the table.

Thanks in Advance Qlikview Community

[danieloberbilli]

try sth like

=sum([Current Tax])

or

=sum({1} [Current Tax])    

if you want to ignore any user selections

if you would like to show both in the same text box then maybe sth like:

='Current Tax: '& sum([Current Tax])  & ' | ' & 'Penalty: '& sum(Penalty)

[Anonymous]

If you want to show both in the same text object, use this text there:

='Current Tax: ' & <expression for the current tax, same is in the table> & chr(10) & 'Penalty: ' & <expression for Penalty>

[sunny_talwar · Accepted solution]

Try this in a text box object:

Current Tax Total: =Sum(Aggr(YourCurrentTaxExpression, Year, Quarter, Payor))

Penalty Total  =Sum(Aggr(YourPenaltyExpression, Year, Quarter, Payor))

HTH

Best,

Sunny

[#5]

Hi Qlikview Community,

Thanks for helping me.

[jagan]

Hi,

You can directly use Sum without Aggr() like below

Current Tax Total: =Sum([Current Tax])

Penalty Total  =Sum(Penalty)

Aggr() will have performance issues, also there is no necessity of using in the current scenario.

Hope this helps you.

Regards,

Jagan.

[#7]

Hi Jagan,

Thanks for sharing your idea and giving some advice to me