Discussion Board for collaboration on QlikView Scripting.
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.
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))
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
Count seems to match, isn't it?