Top 5 and bottom 5 values in a single waterfall chart in Qliksense

Anonymous — Fri, 13 Jul 2018 12:04:53 GMT

Need to show Top 5 and Bottom 5 Brand Group in a single waterfall chart in Qliksense on the basis of share change value.

Also Find sample report as attachment.

Share change for current month

(Sum({<CM_FLG={C}>} [ABI Volume])/

Sum({<[Brand Group] =,CM_FLG={C}>}TOTAL [Industry Volume]))

((Sum({<CM_FLG={P}>} [ABI Volume])/

Sum({<[Brand Group] =,CM_FLG={P}>} TOTAL [Industry Volume])))

)

Thanks in advance

topic Top 5 and bottom 5 values in a single waterfall chart in Qliksense in App Development