topic Re: Formulas in Charts doesn't show correct value in QlikView

Formulas in Charts doesn't show correct value

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to show a formula value in chart, but it doesn't show corect value.

Y have a "Month" as Dimension, and a formula as Expession.

The formula in a text object shows the correct value making any filter. But in chat changes values and graph.

Example for the "current ratio":

Jan: 1.61

Feb: 1.58

Mar: 1.65

Re: Formulas in Charts doesn't show correct value

ajsjoshua — Mon, 02 May 2016 04:25:11 GMT

Hi,

in the chart properties -> Number -> select Expression Default.

Regards,

Joshua.

Chart Object - Number Symbols

Re: Formulas in Charts doesn't show correct value

Mon, 02 May 2016 04:32:09 GMT

Hello,

The problems isn't the format: the chart is showing another values:

as you can see in the images:

ene: TB: 1.61...vs CH: 0.97...

feb: TB: 1.58...vs CH: 2.06...

mar: TB: 1.65...vs CH: 0.58...

Re: Formulas in Charts doesn't show correct value

stephenedberkg — Mon, 02 May 2016 05:14:57 GMT

diegoandresmath

what is your expression?

Re: Formulas in Charts doesn't show correct value

Mon, 02 May 2016 05:29:45 GMT

Hello,

It is a relation. In the expression I have a SUM function. Please, you can see it in the attached QVW file.

Re: Formulas in Charts doesn't show correct value

avinashelite — Mon, 02 May 2016 05:50:14 GMT

please share the expression used in the Text box and the chart

Re: Formulas in Charts doesn't show correct value

sunny_talwar — Mon, 02 May 2016 07:00:14 GMT

Try this expression in your text box object:

=Sum(Aggr(sum({1<BalanceFinal.nvl1 = {'10'}, BalanceFinal.nvl2 = {'10'}, BalanceFinal.RefFecha = {">=$(varFechaIniBalance) <=$(varFechaSeleccionada)"}>}BalanceFinal.Monto)

(sum({1<BalanceFinal.nvl1 = {'20'}, BalanceFinal.nvl2 = {'30'}, BalanceFinal.RefFecha = {">=$(varFechaIniBalance) <=$(varFechaSeleccionada)"}>}BalanceFinal.Monto)*-1), Mes))

Re: Formulas in Charts doesn't show correct value

Mon, 02 May 2016 13:35:04 GMT

Hello,

The expression is both user in the TB and the char, but i have 2 diferent values. The TB's value is correct.

=sum({1<BalanceFinal.nvl1 = {'10'}, BalanceFinal.nvl2 = {'10'}, BalanceFinal.RefFecha = {">=$(varFechaIniBalance) <=$(varFechaSeleccionada)"}>}BalanceFinal.Monto)

(sum({1<BalanceFinal.nvl1 = {'20'}, BalanceFinal.nvl2 = {'30'}, BalanceFinal.RefFecha = {">=$(varFechaIniBalance) <=$(varFechaSeleccionada)"}>}BalanceFinal.Monto)*-1)

Re: Formulas in Charts doesn't show correct value

Mon, 02 May 2016 14:14:29 GMT

Thank you, it's a little close. The values that appear in the text boxes are correct, I have changed you formula suggestion but I have other problem: the graph changes every time i change the filter, in value and in the blue line.

Re: Formulas in Charts doesn't show correct value

sunny_talwar — Mon, 02 May 2016 15:42:54 GMT

So are you trying to avoid it changing based on selection? What selections should it be avoiding?

Re: Formulas in Charts doesn't show correct value

Tue, 03 May 2016 15:42:00 GMT

Hello,

No, the value in both the TB and Char should the the same as the TB shows.

I solved this problems.

I am trying to get a relation between two cumulative values but using Formula in chart and TB. So, the problems was there. The range in the formula is confused when I use 'month' as dimension.

I accumulated values in the QVD file and I use the same formula but without the range.

Re: Formulas in Charts doesn't show correct value

sunny_talwar — Tue, 03 May 2016 15:48:21 GMT

So everything is working now?

Re: Formulas in Charts doesn't show correct value

Tue, 03 May 2016 15:52:33 GMT

Yes it is, thank you for you help.

I used this formula:

sum({<BalanceFinal.nvl1 = {'10'}, BalanceFinal.nvl2 = {'10'}>}BalanceFinal.Monto1)

(sum({<BalanceFinal.nvl1 = {'20'}, BalanceFinal.nvl2 = {'30'}>}BalanceFinal.Monto1)*-1)

The chart is about the current year.

Re: Formulas in Charts doesn't show correct value

sunny_talwar — Tue, 03 May 2016 16:40:57 GMT

Great

I am glad we all were able to help you in some way or the other