Emule Excel Sheet

pgalvezt — Wed, 18 Jul 2012 14:02:05 GMT

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

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!

Re: Emule Excel Sheet

Wed, 18 Jul 2012 14:07:17 GMT

table consists only this dimension and this expression?

pgalvezt — Wed, 18 Jul 2012 14:16:38 GMT

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.