Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

Class Table how to only display last 3 Row ?

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

3 Replies

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

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
Valued Contributor II

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

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 ?

Count seems to match, isn't it?

Capture.PNG

Community Browser