Error to set date on set analysis

[antoniodneto]

Hi guys.

In my DATE FIELD I have values from JAN/2016-DEC/2018.

I'm trying to plot all my graphs starting in DEC/2016.

When I don't specify the DATE my set analysis calc right.

But when I use RangeSum(Above(Sum({<DATA={">=01/12/2016"}>}MBB_CREDITO), 0, 12))
/
RangeAVG(Above(Sum({<DATA={">=01/12/2016"}>}RISCO_TOTAL), 0, 12)) calcs wrong because it "ignore" the previous dates.

How can I fix it? Tks a lot guys!

[Channa]

try to build in script

LOAD

IF(Previous(DIM)=DIM,RangeSum(Peek(MBB_CREDITO),MBB_CREDITO),MBB_CREDITO) AS MBB_CREDITO;
LOAD
*
Resident Main where date>1-12-30

[antoniodneto]

Hi Channa,

Sorry I didn't understand how it works.

What is DIM? How I build my expression?

[Channa]

it is your dimension of table rangesum will repeat based on that dimension

[antoniodneto]

My dimension is DATA

So I did on my script

[TESTE]:
LOAD
IF(Previous(DATA)=DATA,RangeSum(Peek(MBB_CREDITO),MBB_CREDITO),MBB_CREDITO) AS MBB_CREDITO_2;
LOAD
*
Resident T696031_PAINEL_ATACADO_QLIK where DATA>=01/12/2016

But is not working,Did I do something wrong?