Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rittermd
Master
Master

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.

Anonymous
Not applicable
Author

Hi Dauseef,

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

Thanks

Charlie