Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
buzzy996
Master II
Master II

X-Axis objects grouping

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

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

View solution in original post

3 Replies
sunny_talwar

May be try this:

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

buzzy996
Master II
Master II
Author

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

sunny_talwar

Great I am glad I was able to help.