4 Replies Latest reply: Aug 6, 2014 10:02 AM by Francisco Montalva RSS

    Compare equivalent days

      Hello

       

      I'm pretty new to Qlikview, and Recently I am developing a Model for my company. I have to compare the sales (and other fields) of this year with the past year. This looks easy, But sometimes i cant compare today with the same day of the last year, because i cant compare a Monday with a Saturday, or with a Holiday. I try to fix this using a table with two columns, "Day" and "Equivalent Day", but i really dont know how to manage this in the code.

       

      Greetings from Chile, and thank you for help!.