# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
New Contributor III

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

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 ?

4 Replies
Highlighted
Contributor II

## Re: How to convert number format according to required format in qlikview expression

try this ..

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

Highlighted

## Re: How to convert number format according to required format in qlikview expression

May be this?

Simply divide with digit of Money numbers like

Lakhs - 100000

Thousands - 1000

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor

## Re: How to convert number format according to required format in qlikview expression

try using the Num And Num# functions.

Highlighted
MVP

## Re: How to convert number format according to required format in qlikview expression

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