topic Re: Last Year Label in QlikView

Last Year Label

kevbrown — Thu, 15 Sep 2016 09:35:55 GMT

Hi,

I have a small dataset that brings in some financials, a year field and a text field called Season. I'm looking to have 2 sets of data, one for the max financial year selected and one for last. The figures aren't an issue, they're working fine but it's the titles I'm struggling with. For the max year =If(Max(Year)=Year,Season) works, but what do I need to do for the previous year?

Thanks

Re: Last Year Label

sunny_talwar — Thu, 15 Sep 2016 09:37:25 GMT

May be this?

=If((Max(Year) - 1) = Year, Season)

Re: Last Year Label

kevbrown — Thu, 15 Sep 2016 09:39:23 GMT

No, comes up blank

Re: Last Year Label

sunny_talwar — Thu, 15 Sep 2016 09:46:33 GMT

Where exactly are you showing this information? May be try this:

Only({<Year = {"$(=Max(Year) - 1)"}>}Season)

Concat({<Year = {"$(=Max(Year) - 1)"}>}Season, ', ')

Re: Last Year Label

miguelbraga — Thu, 15 Sep 2016 09:47:36 GMT

Hey there,

Can you share a qvw sample so that we can see where you're using this expression.

Might be helpful see this post:

Current Month vs Last Month

Re: Current Years Current Month Vs Last Year Same Month Sales

Regards,

Re: Last Year Label

kevbrown — Thu, 15 Sep 2016 09:50:12 GMT

Worked a treat, thanks