Different results for same expression

joffremota — Tue, 17 Oct 2017 19:28:48 GMT

Hi all.

I'm facing the following situation, and I hope someone could help me.

I've got two charts with the same expression. A simple table and a bar chart.

The logic that I see on the data presentation is...

On the table:

1 employee selected = R$ 229,74

2 employees selected = 229,74 + 229,74= R$ 459,49

On the bar chart:

1 employee selected = (229,74) * 1 = R$ 229,74

2 employees selected = (229,74 + 229,74) * 2 = 918,97

If I select more employees, the total cost (Custo total) on bar chart will grow exponentially, but the total cost on the table(last column) grows correctly.

The expression I'm using is:

=((Sum ({$<[Tipo de Absenteísmo]-={'Licença*'}>}SalarioContratual_Valor)*2.15)/30)*Sum (Absent_DiasMes)

Also, if I choose the dimension Employee (Associado) on the bar chart, it returns the correct value.

Hope someone help.

Regards,

Joffre Mota

Re: Different results for same expression

sunny_talwar — Tue, 17 Oct 2017 19:43:25 GMT

May be try this expression for your chart

Sum(Aggr(((Sum ({$<[Tipo de Absenteísmo]-={'Licença*'}>}SalarioContratual_Valor)*2.15)/30)*Sum (Absent_DiasMes),

Your straight table's dimension)

Re: Different results for same expression

joffremota — Tue, 17 Oct 2017 19:56:05 GMT

stalwar1‌, worked perfectly.

Thank you very much!

Best regards,

Joffre Mota

topic Re: Different results for same expression in QlikView

Different results for same expression

Re: Different results for same expression

Re: Different results for same expression