topic Problem with Above function in QlikView

Problem with Above function

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

Hi All,

The table is showing 2018-2019 data and they want compare sales side by side for the month level,So I have Used above() function to get the required output but in first cell it showing null. I suppose to get value from previous year (2017-2018) value. Is there any way to get required output.The expression like Sum(Sales) = Sum({<Year={max(Year)}>} Sales) and Prev Sales = Above(Sum({<Year={max(Year)}>} Sales).

Here Max(Year) is 2018-2019.

Please help me

Thanks in advance!

regards

Venkey.

Re: Problem with Above function

chrismarlow — Mon, 11 Feb 2019 21:19:00 GMT

Hi,

Try the following;

https://community.qlik.com/t5/New-to-QlikView/First-value-in-above-function/td-p/702033

May take a bit of work with your field names/months (depending how they are set), but should work.

Cheers,

Chris.

Re: Problem with Above function

Vegar — Mon, 11 Feb 2019 22:15:15 GMT

You do not need to use ABOVE, you could just use plain sum aggregation of you adjust your expressions a bit.

Latest year
Sum({<Year={"$(=max(Year))"}>} Sales)

Previous year
Sum({<Year={"$(=max(Year)-1)"}>} Sales)