Class Table how to only display last 3 Row ? - Qlik Community

paulyeo11 · ‎2016-03-23

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

sunny_talwar · ‎2016-03-23

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))

paulyeo11 · ‎2016-03-23

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.

sunny_talwar · ‎2016-03-23

Count seems to match, isn't it?