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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

May be try this:

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

View solution in original post

3 Replies
sunny_talwar
MVP
MVP

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
MVP
MVP

Great I am glad I was able to help.