topic num format percentage in QlikView

num format percentage

cbaqir — Fri, 15 Nov 2024 23:49:12 GMT

In a text box, my expression shows 0.99088036603823 but no matter how I use the num format, I can't get it to show 99.x%. Any ideas?

=1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours])

This expression shows 1.00:

=num(1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours]),'##.#0')

Re: num format percentage

Kushal_Chawda — Mon, 12 Oct 2020 22:50:01 GMT

@cbaqir try below

num(1-if(aggr(sum(pte_build)+sum(pte_design),month,PRIMARY_DEFINE_BODY)=0, aggr(sum(est_np_build)+sum(est_prod_build)+sum(act_np_build)+sum(act_prod_build)+sum(actual_design),month,PRIMARY_DEFINE_BODY),
aggr(sum(pte_build)+sum(pte_design),month))/sum([Available Hours]),'##.#0%')

Re: num format percentage

cbaqir — Mon, 12 Oct 2020 22:56:21 GMT

Whoops. It was actually an issue with the Test in Chart in my Pie chart. Thanks!