Chart - Date without "hour" and "minute"

[#1]

Hey!!

I need your help with Qlikview! I have a table with 5 columns. The first one is the date (with hour and minute) and the other 4 are values. I would like to plot 4 lines with the average per day.  And I want also my X-Axis to have dates from different months (for example from 15.08 to 15.09).

The problem is that if I choose "Date" as Dimension, than I get in X-Axis a value for every different hour and minute!!! And if I chooss "Day" as X-Axis then I cannot have in the same X-Axis days from different months... How can I solve this problem? Maybe with a "Set analysis"???

Thank you very much for your help and time!!!!!

Eduardo

[#2 · Accepted solution]

It sounds like your date field in a timestamp function. You can use Date(floor([Your date field]),'MM/DD/YYYY') to get it to just the actual date.

[#3]

Thank you very much!!! You solved my problem so quickly!!

Eduardo