Emule Excel Sheet

[pgalvezt]

Hello, I just finish a dashboard in QlikView but now I have to create a resume table with my expressions that I have created.

In my dashboard information appears like this:

Today Commerce Total

Today Commerce Total

Today Commerce Total

Today Commerce Total

I need to create a Table like this

Today Commerce Total General.

My expression is:

=RangeSum(

if(aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)= vDate, 'Today',

if(aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, 'Day 2',

if(aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60, 'Day 3''))))

Nothing Happened.The table still show me many Today and no just one today (Like Group).

Thank You!

[#2 · Accepted solution]

table consists only this dimension and this expression?

[pgalvezt]

Thanks Pari for your reply But I get it. I used my rangesum expression like dimenssion in another pivot, Now I can see That I wanted.

Thanks Again.