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