topic Re: Number into Percentage format in App Development

Number into Percentage format

Karthick30 — Thu, 23 Dec 2021 19:01:02 GMT

Hello,

I am using Sum(sales) as measure and year and Region as Dimension. I have total 5 regions. I am using vizlib Stacked bar chart in qliksense. I am getting value as 8 digits like 32123567.. but I would like to show it as % format. tried to changed it to Number and used % from option , but its giving 32123567%..

I need to show like US:60% , Mexico:35% like this.. Any idea on this

Re: Number into Percentage format

vijaynov — Thu, 23 Dec 2021 19:05:27 GMT

Sum(sales)/sum(total sales)*100 & %

Re: Number into Percentage format

Karthick30 — Thu, 23 Dec 2021 19:26:18 GMT

Thanks . But already I am using Sum(total sales) in measure.. I am seeing 5 segments in my stacked bar chart for each bar. how to enter sum(sales) for each Region

Re: Number into Percentage format

Karthick30 — Fri, 24 Dec 2021 09:33:45 GMT

In detail, I am using 2 Dimensions .( Year and Region) and 1 measure as Sum( sales).. so i am getting one bar with stacked 5 regions.. and values showing as 2314534 for one region , 134xxxxx for one region.. how to convert this as %. since i am using Sum(sales) already in measure , how to calculate region wise %. Any idea is greatly appreciated

Re: Number into Percentage format

AlexGol — Fri, 24 Dec 2021 11:42:00 GMT

You need to make changes in your measure. Instead of Sum (sales) type Sum(sales)/sum(total sales)*100, as person above said. Choose % in Data->Select Measure->Number formatting. This should work if you described your problem correctly.

Re: Number into Percentage format

Karthick30 — Fri, 24 Dec 2021 12:23:43 GMT

Sorry. Sum(total sales) is what I am using in measure.. how to calculate sum(sales) for each region..