topic Re: Year-to-date flags on selection in QlikView

Year-to-date flags on selection

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

Is there anyway to make an expression that is based on the selection of the year?

At the moment, I have expressions that include variables for current year-to-date and prior year-to-date so they show data for 2018 and 2017. But i have data going back other years that would be good to see year-on-year for so depending on the selected year, I would want to see the year-to-date for that year and then the year-to-date for the year before.

Is that possible?

Re: Year-to-date flags on selection

sunny_talwar — Wed, 11 Apr 2018 13:24:35 GMT

Year to date when year is selected will be the whole year, right?

Re: Year-to-date flags on selection

MK_QSL — Wed, 11 Apr 2018 13:24:57 GMT

I think you have used Today() in your YTD and LYTD expressions.

Just replace Today() with user selected dates... i.e. Max(YourDateField)

Something like below..

YTQ, QTD, MTD and WTD

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

YTD,QTD,MTD,WTD IN Qlik Sense

Re: Year-to-date flags on selection

jonathandienst — Wed, 11 Apr 2018 13:28:03 GMT

Use set expressions with syntax along these lines

{<Year = {'$(=Max(Year))'}, ... >}

{<Year = {'$(=Max(Year)-1)'}, ... >}

You may need to override the actual selection, if you are making date selections in fields other than year. Max() will produce the latest (current) year when nothing is selected, or the selected year if when a selection is made.

Re: Year-to-date flags on selection

avinashelite — Wed, 11 Apr 2018 13:28:40 GMT

In your case set the YTD for all the years base on the date and use the addyear() function mark the required year to date

Re: Year-to-date flags on selection

khaycock — Wed, 11 Apr 2018 14:03:07 GMT

But I was thinking that I would need an expression to have a year-to-date based on the month picked so if March

But I think I need an expression that shows YTD regardless of the year clicked so at the moment its 2018 and 2017 but if 2015 was selected then it needs to show that instead? Does that make sense?

Re: Year-to-date flags on selection

sunny_talwar — Wed, 11 Apr 2018 14:10:18 GMT

So, in that case a front end set analysis based expression is the way to go... Manish shared links where you can look at the set analysis that can be used