topic Re: Num function formatting on Gauge chart in QlikView

Num function formatting on Gauge chart

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

Hi Champs

I am using below expression in my Gauge chart which works fine cause i am getting correct results.

My problem is to format value according to the clients

Totals value is =0.00002337 then client need to see only 2 not 0.02 etc cause i used many Num FUNC last one was '#%' then i get 0.02 .how to can i omit the first 5 zeros to get 2 as value?

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number),'#%')

Thanks

Re: Num function formatting on Gauge chart

sunny_talwar — Wed, 24 Jan 2018 15:53:52 GMT

May be multiply by 100?

Re: Num function formatting on Gauge chart

mandilicious — Wed, 24 Jan 2018 16:05:28 GMT

Hi Sunny

I used * 100 in below it seems to be working

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number)*100,'#%')

Thanks

Re: Num function formatting on Gauge chart

mandilicious — Thu, 25 Jan 2018 07:41:54 GMT

Hi Sunny

I thought by using '#%' solved formatting function but after i refreshed my dashboard today is still show 0.8 instead of only 8%

Re: Num function formatting on Gauge chart

sunny_talwar — Thu, 25 Jan 2018 09:45:43 GMT

Try this

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number)*100,'##.%')

Re: Num function formatting on Gauge chart

mandilicious — Thu, 25 Jan 2018 11:04:54 GMT

Hi Sunny

Thanks,after using '##.%' i am getting 0.

Re: Num function formatting on Gauge chart

sunny_talwar — Thu, 25 Jan 2018 12:10:08 GMT

What if you multiply by 1000 instead of 100

Re: Num function formatting on Gauge chart

mandilicious — Thu, 25 Jan 2018 14:28:34 GMT

Hi Sunny

It worked if i may ask why we multiply by 1000 instead of 100 ?

Re: Num function formatting on Gauge chart

sunny_talwar — Thu, 25 Jan 2018 14:29:54 GMT

Because it seems that you number was showing up as 0.008 and to make it 0.08, we had to multiply it by 1000 instead of 100

Re: Num function formatting on Gauge chart

mandilicious — Thu, 25 Jan 2018 15:11:16 GMT

Sunny you are the best Thanks