Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hi Channa,
Sorry I didn't understand how it works.
What is DIM? How I build my expression?
it is your dimension of table rangesum will repeat based on that dimension
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?