topic Re: X-Axis objects grouping in QlikView

X-Axis objects grouping

buzzy996 — Tue, 27 Oct 2015 13:45:44 GMT

hi guys,

may i know,how to group same date objects on x-axis not from load statement?

note:

x-axis: =Aggr(Date(CREATETS,'dd/MM/yy'),TASK_REF)

y-axis is here:=Count({$<DOCTYPE={'Inbound'}>}TASK_REF)

thanks

sunny_talwar — Tue, 27 Oct 2015 13:47:58 GMT

May be try this:

=Aggr(Date(Floor(CREATETS),'DD/MM/YY'),TASK_REF)

buzzy996 — Tue, 27 Oct 2015 14:25:27 GMT

tht's right sunny,thank you..i missed/forgotten the use of floor.

sunny_talwar — Tue, 27 Oct 2015 14:26:44 GMT

Great I am glad I was able to help.