Qlik Community

Qlik Sense App Development

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

timorbit
New Contributor III

Point in time using Set Analysis

Hi Folks,

I drag a line chart with Year and Products as a Dimension and the following expression Sales:

sum({<Year={">=$(=MAX(Year)-1)<=$(=MAX(Year))"}>}VALUE)

Now I get all of my Products you see here: I like to select three of my products, not all. How should I change my expression? Thanks!

1 Solution

Accepted Solutions
jwjackso
Contributor III

Re: Point in time using Set Analysis

Try

sum({<Year={">=$(=MAX(Year)-1)<=$(=MAX(Year))"},Products={'Prod1','Prod2','Prod3'}>}VALUE)


where Products is the dimension and Prod1 is a product that you want to display

4 Replies
jwjackso
Contributor III

Re: Point in time using Set Analysis

Try

sum({<Year={">=$(=MAX(Year)-1)<=$(=MAX(Year))"},Products={'Prod1','Prod2','Prod3'}>}VALUE)


where Products is the dimension and Prod1 is a product that you want to display

timorbit
New Contributor III

Re: Point in time using Set Analysis

Hi Jerry,

Thanks a lot, it works

timorbit
New Contributor III

Re: Point in time using Set Analysis

Hi Jerry,

now I get something like this:

But I want both lines ending in 2017. But I am doing wrong?

Additionaly I want to create two charts like this. One place the rising sales from 2016 to 2017 and the second chart only the falling sales from my Products. How could I do that?

jwjackso
Contributor III

Re: Point in time using Set Analysis

I'm guessing Year is coming from a calendar.  You could replace =MAX(Year) with a variable that is set to a 2017.


For the second, you use an If test.  Check it the product sales is greater in 2016 than 2017.  Something like:  If(Sum({<Year={'2016'}>} VALUE) > Sum({<Year={'2017'}>} VALUE),1,0).  Hide the expression, suppress zero.  That should be all the rising products.  Reverse it to find the falling products.

Community Browser