Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set Analysis Quick Question

Hi I am new to Qlik and have a quick question about set analysis.

The below arrangement is what I am trying to display using my data:Set Analysis picture.png

So I want to show a particular measure for year to date on a line graph and compare it with the same date last year. Displaying this on one graph is what I am struggling with.

Help is much appreciated.

Thanks

2 Replies
Highlighted
rittermd
Honored Contributor

Re: Set Analysis Quick Question

Without knowing your data you could simply add Set Analysis to the expression where you only Sum or Count when the Year field = '2015' or whatever year you are looking for.

Count ({<Year={'2015'}>} Amount)

Do the same thing for the other line with a different year value.

Of course this means the values are hard coded and you would have to change them for other years.

charlie_mstrmnd
New Contributor III

Re: Set Analysis Quick Question

Hi Dauseef,

Please see this post around YTD values: QlikView App: Simple Year To Date Example (Set Analysis)

Thanks

Charlie