Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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!

2 Replies
Valued Contributor III

Re: Year over Year display

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

Not applicable

Re: Year over Year display

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

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.