2 Replies Latest reply: Feb 18, 2013 7:31 AM by Nazeem Soeltan RSS

    Filter data on workdays and weekends

      Dear Qlikview developers,

       

      I'm developing a dashboard where I need to display a chart with the time or date on the x-axis and the gas consumption on the y-axis.
      I need to 'filter' the data according to the type of day. I need to make a distinction between workdays and weekends.

       

      For example, when i click on a button "Mon - Fri", only those days with gasconsumption values must be shown in the chart.
      The same applies to weekends.
      How can I accomplish the above? I'm have a master calendar.

       

      Thanks for your help

       

      Kind regards,

       

      Nazeem

       

      edit: Added the fact that I'm have a master calendar.