topic Re: Bar chart issue in QlikView

Bar chart issue

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community

I have a bar chart and it works well, but If I choose a specific bar that shows "No data on display".

without selection working fine as below...

while select any bar, as below..

Could you please assist.

Re: Bar chart issue

MayilVahanan — Fri, 30 Oct 2020 02:50:49 GMT

Hi @paulwalker

Try like below

DUAL(MUPC_FAMILY_SHORT_TITLE &' '& (NUM(((Avg(BASE_SALARY)-AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE)))
/
AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE))), '##.##%')),

((Avg(BASE_SALARY)-AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE)))
/
AVG({<MUPC_FAMILY_SHORT_TITLE=>}TOTAL AGGR(AVG({<MUPC_FAMILY_SHORT_TITLE=>}BASE_SALARY), MUPC_FAMILY_SHORT_TITLE))))

Re: Bar chart issue

paulwalker — Fri, 30 Oct 2020 02:58:39 GMT

Thanks Mayil 🙂