topic Which year has max sales in QlikView

Which year has max sales

rajveersinghsisodiya — Sun, 31 Jan 2016 17:48:23 GMT

Hi All,

I have a line chart with month as dimension

i have monthly wise five year of data including current year.

requirement are:

1. One line as Current year sales data

2. And another line as year which has max sales.

swuehl — Sun, 31 Jan 2016 19:11:22 GMT

Max sales total on a given year or max sales on a month?

sunny_talwar — Sun, 31 Jan 2016 20:29:09 GMT

Looking for something like this?

swuehl — Sun, 31 Jan 2016 20:47:37 GMT

You can simplify the set expression a bit using Rank() function:

=Sum({<Year = {"=Rank(Sum(Sales))=1"}>}Sales)

And if the OP wants to find the year with max monthly sales:

=Sum({<Year = p({<MonthYear = {"=Rank(Sum(Sales))=1"}>}) >} Sales)

Attached the modified version of Sunny's sample

rajveersinghsisodiya — Mon, 01 Feb 2016 14:30:05 GMT

Hi swuehl‌ thank you so much ...:).

sunny_talwar — Mon, 01 Feb 2016 14:57:00 GMT

So what were you looking for? The first solution or the second one. Just curious

rajveersinghsisodiya — Mon, 01 Feb 2016 15:20:19 GMT

actually i have used the expression given by SWUEHL .. i haven't open the example given by you... because i am using personal edition .

sunny_talwar — Mon, 01 Feb 2016 15:24:18 GMT