2 Replies Latest reply: Jul 7, 2015 6:42 PM by Kendrick Huynh RSS

    Year over Year display

      Hi, I'm new to Qlik Sense and not too savvy with coding/set analysis.

       

      I would like to first create,basically, the first chart shown in this blog: Year-over-Year Comparisons

      However, I'm not sure how to construct it in Qlik Sense. I have months (named PERIOD in my data set and spanning from 2010 to 2015) set as a dimension, but I'm unable to add the PERIOD field as a dimension twice on the line chart. I suspect that the expressions need to be modified.

       

      After creating this line chart, I'd like to compare something like last month's sales with current month sales as a positive or negative KPI indicator, possibly even incorporated as a green or red value within a table I've created. Based on how the user filters the month, I'd like for it to compare current selected months (for example Apr, May, Jun 2014) with the immediate prior months (Jan, Feb, Mar 2014). I'm confident this is possible, I just am unsure of how to accomplish this. I appreciate any thoughts and feedback in advance!

        • Re: Year over Year display
          Sinan Ozdemir

          If you could post a sample data, we can take a look and send you a QVF file.

            • Re: Year over Year display

              Sure,  a very limited view of the data looks something like this:

               

              PERIODBRANDSALES UNITSSALES VALUE EURPRICE EUR
              2013-08Brand C0055
              2012-09Brand C0054
              2014-10Brand C100
              2014-07Brand B0120
              2014-08Brand B0120
              2014-09Brand B0120
              2015-01Brand B0113
              2012-11Brand A019
              2011-11Brand C111
              2012-09Brand B111
              2014-01Brand C111
              2010-08Brand B111
              2011-07Brand A111
              2014-01Brand C111
              2014-02Brand A211

               

              I'd like to know how to write the expression for a master measure that shows YoY % change in [Sales Value Eur], and the expression for a master measure that shows % change of [Sales Units] and [Price Eur] between the current selected months and the same number of months directly prior to those selected

               

              For example, if the user selects Apr May Jun, the the measure would either sum the sales units or average the price of those months and compare it to Jan Feb Mar's sum sale/average price to ultimately show a positive or negative % growth (incorporating a green and red color code would be awesome). Alternatively, if the user just selects Apr, then it would compare Apr's values with Mar's values.

               

              I know this is a lot to ask, so if anyone can provided resources on learning the syntax, I'd greatly appreciate it.