Qlik Community

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
dhavalvyas
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
johnhhtp2
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
narenjln
Contributor

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

try using the Num And Num# functions.

Highlighted

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