topic Problem with Sum and Set Analisys in Brasil

Problem with Sum and Set Analisys

ronald_gdi — Tue, 08 Mar 2016 19:52:11 GMT

I have a table with many rows

Format Data = DD/MM/YYYY

Fields: Data <> Pontos Possiveis <> Pontos Conquistados

Rows: 01/01/2016 20 10

01/02/2016 20 20

I have this expression

Sum({<Mês=,Ano=,Data={"=$(vDataPesquisaRED)"}>} [Pontos Conquistados)

Sum({<Mês=,Ano=,Data={"=$(vDataPesquisaRED)"}>} [Pontos Possiveis])

The variable vDataPesquisaRED return the Max Date

The result would be 1, because (20 / 20)

But my results is 0,75, because (30 / 40)

I don't know why the Qlik return 0,75, the correct is 1

Can someone help me?

Kind regards

sunny_talwar — Tue, 08 Mar 2016 19:54:53 GMT

Can you try this without the variable:

Sum({<Mês=,Ano=,Data={"$(=Date(Max(Data)))"}>} [Pontos Conquistados)

Sum({<Mês=,Ano=,Data={"$(=Date(Max(Data)))"}>} [Pontos Possiveis])

maxgro — Tue, 08 Mar 2016 20:01:57 GMT

the expression

Sum({<Mês=,Ano=,Data={"$(vDataPesquisaRED)"}>} [Pontos Conquistados])

Sum({<Mês=,Ano=,Data={"$(vDataPesquisaRED)"}>} [Pontos Possiveis])

and the variable

=Date(Max(Data))

ronald_gdi — Wed, 09 Mar 2016 01:46:08 GMT

This option doesnt' work too.

If I put AGGR command into a Aggregate Dimension:

Aggr(Sum({<Mês=,Ano=,Data={"$(=Date(Max(Data)))"}>} [Pontos Conquistados)

Sum({<Mês=,Ano=,Data={"$(=Date(Max(Data)))"}>} [Pontos Possiveis),Data)

This code returns a table containing the calculated data by date. And I need to catch the last month , I need to add another code. I do not know.

I have a example with real data

ronald_gdi — Wed, 09 Mar 2016 01:46:24 GMT