1 Reply Latest reply: Aug 4, 2013 5:14 PM by Daniel Kohler RSS

    Creating Date Filters with Different Date Fields

      Hello all,

       

      I am pretty new to Qlikview and I am trying to create a report. I need to have all different date filters

      such as months, quarters and fiscal years.

      The problem  is I have different charts with different date range. For example for one chart I need

      to have volumes based on sent date and in another chart I need volumes based on the response date.

      When I want to create these  time filters I need to create them based on 1 date ( as a surce) but I don't want that applies to all

      charts in my tab.

      (I have all the dates in one table in my data model).

       

      So if you faced the same issue I appreciate if you let me know.

       

      Thank you,

      Behnaz

        • Re: Creating Date Filters with Different Date Fields
          Daniel Kohler

          Hi Behnaz

           

          you could create a master calendar with month, quarter, year,... as an island table.

          There are many script examples in the community how to create a calender.

          In the chart objects you need to work with set analysis expressions.

           

          Example:

          Create variables for your date fields (Crtl + Alt + V)

          vYear  =Concat(DISTINCT DateIslandYearField,Chr(39)&','&Chr(39))

           

          Chart 1 Expression:

          sum( {$<SentDateYear = {'$(vYear)'} >} Volume)

           

          Chart 2 Expression:

          sum( {$<ResponseDateYear = {'$(vYear)'} >} Volume)