topic Re: Prior Year's Information Displayed in Table Box in QlikView

Prior Year's Information Displayed in Table Box

Wed, 28 Jan 2015 16:24:53 GMT

I need help displaying the previous year's information in a Table Box. The report is for Outside sales to Snapshot and take on the go. It's a Pack - N - Go style report were it allows the outside sales person to select a District, Company, or Customer and gain a valuable knowledge before visiting said customer.

Setting up the Current Year's Table Box was easy, but I wanted to set up a prior year's Information box based on what year is selected, if no year is selected to have it show the Current Year Minus One.

Re: Prior Year's Information Displayed in Table Box

robert_mika — Wed, 28 Jan 2015 16:34:18 GMT

Could you attached your file?

Re: Prior Year's Information Displayed in Table Box

Wed, 28 Jan 2015 16:37:06 GMT

The full QVW file?

Re: Prior Year's Information Displayed in Table Box

johnca — Wed, 28 Jan 2015 19:02:22 GMT

Hi Matt,

Here's one example using a YEAR field that will change based on a selection in YEAR;

Sum({<YEAR={$(=Max(YEAR)-1)}>} Value)

Assuming Max(YEAR) = the current year select nothing and it returns last year's data. Select 2014 and it returns 2013 data, etc.

HTH,

John