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

[dhavalvyas]

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]

try this ..

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

[Anil_Babu_Samineni]

May be this?

Simply divide with digit of Money numbers like

Lakhs - 100000

Thousands - 1000

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

[Anonymous]

try using the Num And Num# functions.

[avinashelite]

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,##', ',', '.')))