How to calculate Date Difference...

[hamzabob1]

hello all,

i would like to display my date in the following manner can anyone know how to do that...

Company Name	Location	0-15 days	16-30 days	31-40 days	41-60 days	61-90 days	91-180 days	181-360 days	Above 360 days	Grand Total
a	ABC	-	0.24	0.08	-	-	-	-	-	0.32
b	RON	0.06	0.15	-	-	-	-	-	-	0.21
c	T.N	0.03	0.18	-	-	-	-	-	-	0.21
d	T.N	0.16	0.02	-	-	-	-	-	-	0.19
e	A.P	0.14	-	-	0.05	-	-	-	-	0.19
f	XYZ	-	-	0.12	0.05	-	-	-	-	0.17

[PrashantSangle]

Hi,

See

Buckets

It will help your.

Regards

[Anonymous · Accepted solution]

see these threads:

Creating Aging Buckets within QlikView

Creating Buckets in the Load Script

[hamzabob1]

wowwww..thank you all