topic Re: Variables and Set Analysis in App Development

Variables and Set Analysis

john_delligatti — Fri, 02 Feb 2018 14:49:18 GMT

Hi All,

I am attempting to use a variable for max year in order to create a chart showing year over year pricing increases in Qliksense. I've successfully created the chart using if( Year='2017',avg( [Unit Price],)) , same with 2016 and so forth. That said my boss is encouraging me to use variables to accomplish this to get familiar with them for future use.

I have the variable name set to vCurrentYr, with the variable set to max([Year])

To ensure I created the variable correctly I dropped it into a KPI box and it returned 2017, the max year from my data set.

However, when I enter the variable into my equation, I cannot for the life of me get it to work. The equation I've created is avg({$<[Year]={$(vCurrentYr)}>}[Unit Price])

I've looked at all the posts I can find in this forum as well as youtube videos, as far as I can tell the syntax is correct. Would someone be able to assist?

Thank you.

Re: Variables and Set Analysis

sunny_talwar — Fri, 02 Feb 2018 16:54:46 GMT

Try to add an equal sign after the parenthesis within the dollar sign expansion

Avg({$<[Year]={$(=vCurrentYr)}>}[Unit Price])

Re: Variables and Set Analysis

john_delligatti — Fri, 02 Feb 2018 17:05:06 GMT

Hi Sunny,

Thank you for your reply. Unfortunately it did not solve the issue, the equation returns blank.

Re: Variables and Set Analysis

sunny_talwar — Fri, 02 Feb 2018 17:07:08 GMT

How about this

Avg({$<[Year]={$(=$(vCurrentYr))}>}[Unit Price])

Re: Variables and Set Analysis

john_delligatti — Fri, 02 Feb 2018 17:21:00 GMT

That did it! Thank you!!