2 Replies Latest reply: Oct 26, 2012 11:31 AM by eduqlikview RSS

    Chart - Date without "hour" and "minute"

      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