topic Re: Class Table how to only display last 3 Row ? in QlikView

Class Table how to only display last 3 Row ?

paulyeo11 — Wed, 23 Mar 2016 09:52:23 GMT

Hi All

My Table have more then 10 row of data .

My objective is just to highlight the impt of high sales contribution sales. it there any i can only display the last 3 row of the table ?

meaning in 2016 display 1 and 2015 display 1+1 =2

As in my actual table i have many column , because i have many year and not just 2 yr.

Paul

Re: Class Table how to only display last 3 Row ?

sunny_talwar — Wed, 23 Mar 2016 09:57:00 GMT

May be change your calculated dimension to this:

=class(aggr(If(sum(sales) > 700000, Sum(sales)),year,company),

pick(wildmatch(SOURCE, 'TDSPG', 'TDSS', 'ADL', 'TDSKL', 'TDST'),

$(iDiffValues) * 1, $(iDiffValues) * 1,$(iDiffValues) * 1,$(iDiffValues) * 1, $(iDiffValues)*1))

Re: Class Table how to only display last 3 Row ?

paulyeo11 — Wed, 23 Mar 2016 10:07:51 GMT

Hi Sunny

Your table is what i am look for , but then it give the wrong count of high sales contribution account. This is cause by you filter off one of the account which is more then 700,000

Paul.

Re: Class Table how to only display last 3 Row ?

sunny_talwar — Wed, 23 Mar 2016 10:19:56 GMT

Count seems to match, isn't it?