2 Replies Latest reply: Sep 22, 2011 2:16 PM by Rob Wunderlich RSS

    how to get YTD values for a time dimension like month???

      Hi, 

      I have a line chart using month dimension and an expression, I also have a list box with same month dimension, if I select a particular month the chart should show data till the selected month continously... how to achieve this? I have tried set analysis but I have learnt that in this case, set analysis works for a measure but not a dimension... Any help in this would be appreciated.

       

       

       

      Thanks in advance...

       

       

      Thanks & regards

      Prerana

        • how to get YTD values for a time dimension like month???

          I Think you should work with date as YEAR , MONTH and DAY.

          But I think you shoul post your qvw for us to check out.

           

          Also look at the examples below.

          hope it helps.

           

           

          day( date )

          Day. Returns an integer representing the day when the fraction of expr is interpreted as a date according to the standard number interpretation.

           

           

          Example:

          day( 1971-10-30 ) returns 30.

           

           

          If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. To solve this problem, you can either change the settings or use the date# interpretation function.

           

           

          week( date )

          Week number. Returns an integer representing the week when the fraction of expr is interpreted as a date according to the standard number interpretation.

           

           

          Example:

          week( 1971-10-30 ) returns 43.

           

           

          If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.

           

           

          month( date )

          Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.

           

           

          Example:

          month( 1971-10-30 ) returns Oct.

           

           

          If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.

           

           

          year( date )

          Year. Returns an integer representing the year when the fraction of expr is interpreted as a date according to the standard number interpretation.

           

           

          Example:

          year( 1971-10-30 ) returns 1971.

           

           

          If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.

          • how to get YTD values for a time dimension like month???
            Rob Wunderlich

            Add the set selection into your measure. It will automatically "extend" your dimension to show all the dimension values selected by the set.

             

            -Rob

            http://robwunderlich.com