topic Re: Show net amount in chart in QlikView

Show net amount in chart

Thu, 07 Jan 2016 19:46:56 GMT

I am currently using this formula:

num(SUM ([JOURNAL DR])-SUM ([JOURNAL CR]), '$#,##0')

What I am trying to accomplish, is showing the actual solution to the above equation in the the "Window Tile" or "Show tile in chart" as a $ figure or in the "Window Tile". I am currently using a pie chart but the equation is showing in the window tile. I would like for the actual net amount to show.

Thank you,

Manny

Re: Show net amount in chart

sinanozdemir — Thu, 07 Jan 2016 19:59:16 GMT

Maybe try the below:

num(SUM (Total [JOURNAL DR])-SUM (Total [JOURNAL CR]), '$#,##0')

Re: Show net amount in chart

Anonymous — Thu, 07 Jan 2016 20:01:26 GMT

Did you put an equals sign before it, as in :

=num(SUM ([JOURNAL DR])-SUM ([JOURNAL CR]), '$#,##0')

Re: Show net amount in chart

Thu, 07 Jan 2016 20:09:33 GMT

Thanks for the help Sinan. That did the trick along with the "=".

Re: Show net amount in chart

Thu, 07 Jan 2016 20:10:27 GMT

Thanks for your assistance Bill.

Re: Show net amount in chart

jduenyas — Thu, 07 Jan 2016 20:27:11 GMT

Yeah

Always put an "=" sign to show value in an area that is designated for text.

you van also combine text and numbers like so:

='enter some text ' & sum(your formula)

(Note that in this case you should not repeat the "=" sign before the function Sum() )