This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a data where the customer wants to see the top 5-10 engine model performers.
is the max function teh best one to use to make a chart show me the top ten? also how would i use it?
my field name/measure that i want to see is STD_Count, and the values in the field are just numbers i.e. 14,20,200,308.
i just want the top ten shown on the chart. my dimension is labled 'ENG_MDL'
=if(Aggr(Rank(Sum(STD_Count)), ENG_MDL)<=10, ENG_MD, 'Others')
View solution in original post
This is perfect, thank you!