topic Re: Multiple period selection in QlikView

Multiple period selection

tim_leijen — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm trying to create a graph which shows the YTD data and the YEAR TO GO (the Year to go would be the budget minus the YTD months) However I don't know how to create an expression which works separate from the period selection table...

Re: Multiple period selection

Or — Mon, 30 Jul 2018 08:48:27 GMT

sum({<Period = >} YearToGoBudget)

Have a look at the help / online resources for set analysis for more information.

Re: Multiple period selection

jyothish8807 — Mon, 30 Jul 2018 08:58:01 GMT

Hi Tim,

Try this:

YTD: sum({<Date=, Date={'<=$(=date(max(date)))>=$(=date(Yearstart(max(Date))))'}>}Budget)

Year to Go: sum({<Date=, Year={'$(=Year(Max(Date)))'}>} Budget)

- sum({<Date=, Date={'<=$(=date(max(date)))>=$(=date(Yearstart(max(Date))))'}>}Budget)

Br,