Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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.
Hi Dauseef,
Please see this post around YTD values: QlikView App: Simple Year To Date Example (Set Analysis)
Thanks
Charlie