26 Replies Latest reply: Feb 18, 2014 5:12 AM by qlik learn RSS

    Display data in a chart from dates sorted by weekdays



      My chart is Time (x-axis) to Amount of Sales (y-axis). Time and Date are my key fields. All my data is loaded from an excel sheet as a crosstable.

      I would like my chart to display the Amount of Sales from only Monday, or Tuesday, or Wednesday, etc.

      I have tried a lot of things like the weekday() function, but nothing has worked for me.

      Could you please help me?


      Best Regards,