topic Re: Displaying Value on Text Object in QlikView

Displaying Value on Text Object

Mon, 22 Jun 2015 01:26:07 GMT

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 — Mon, 22 Jun 2015 01:50:12 GMT

try sth like

=sum([Current Tax])

=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 — Mon, 22 Jun 2015 01:51:58 GMT

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 — Mon, 22 Jun 2015 01:53:59 GMT

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

Mon, 22 Jun 2015 02:04:54 GMT

Hi Qlikview Community,

Thanks for helping me.

jagan — Mon, 22 Jun 2015 02:35:59 GMT

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.

Mon, 22 Jun 2015 02:43:39 GMT

Hi Jagan,

Thanks for sharing your idea and giving some advice to me