How to convert number format according to required... - Qlik Community

dhavalvyas · ‎2017-12-01

Hi,

Suppose I have count of policies is in crore if I want it in lakhs, thousands also in decimals so how to write expression for that ?

Anonymous · ‎2017-12-01

try this ..

num(sum(sales),'#,##,##,##0.00')

Anil_Babu_Samineni · ‎2017-12-01

May be this?

Simply divide with digit of Money numbers like

Lakhs - 100000

Thousands - 1000

Decimal - Num(Measure, '#.##.#0')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-12-01

try using the Num And Num# functions.

avinashelite · ‎2017-12-01

currently we don't have direct way to do this ..we need to handle this in the expression level ...like this

if(Sum(Sales) > 1000000, num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),

if(Sum(Sales) > 1000, num(Sum(Sales)/1000, '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))

How to convert number format according to required format in qlikview expression