top n records in bar chart

[anat]

hi , source data:     LOAD * Inline  [  Year,Loc,Sales,Target  2015,a,100,200  2015,b,250,150  2015,c,50,100  2016,a,250,200  2016,b,200,20  2016,c,350,200  2016,d,10,5  2017,a,300,200  2017,b,100,300  2017,c,400,200  ]  ;  need output like below in  bar chart:   Year Loc Sales Target 2017 c 400 200 2017 a 300 200 2016 c 350 200 2016 a 250 200 2015 b 250 150 Requirement: top 5 records based on sum(Sales) and year descending order. dimensions: Year,Loc Expression : for Sales =Sum({} Target) in table output coming properly but when i create bar chart output not in required format.

[anat]

linking to existing thread: https://community.qlik.com/thread/291823

[arvind_patil]

Hi Anant,

Please share expected output in bar chart sample.

Thanks ,

Arvind Patil

[anat]

Hi Arvind,

PFA...the expected output in bar chart.