Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
h_prakash
Contributor

Qlik Sense Num Format for Calculated Dimension

Hi All,

This is In Qlik Sense

I am trying to convert one dimension in to Number format.

Dimension Called Project Number and I need to show the all the Active project numbers. so I have written like this

Dimension:

if(Status='Active', [Project Number]) in the front end.

But in the out put of this dimension I am getting in string format. I have tried both Num() and Num#()

Num(if(Status='Active', [Project Number])),

if(Status='Active', Num([Project Number]) ),

Num#(if(Status='Active', [Project Number])),

if(Status='Active', Num#([Project Number]) )

But still I am getting in the string format.

Please help.

Thanks

Prakash

Tags (1)
4 Replies
sibusiso90
Contributor II

Re: Qlik Sense Num Format for Calculated Dimension

In qlik Sense you need to fully define it

for example num(sales, '# ##0.##','.',' ') were the first one shows the format the second one shows the decimal delimiter and the third one shows the thousand delimiter.

sibusiso90
Contributor II

Re: Qlik Sense Num Format for Calculated Dimension

Sorry I didn't see the last part.

Please find the attached document for the sample where I used a the second option and just tweaked it with the formatting and it works fine.

if(Status='Active', Num([Project Number],'# ##0','.',' '),[Project Number])

Highlighted
h_prakash
Contributor

Re: Qlik Sense Num Format for Calculated Dimension

Hi Phumelo,

Thank you for the response. I think you did not attached any document.

Thanks

Hari

sibusiso90
Contributor II

Re: Qlik Sense Num Format for Calculated Dimension

This is the attachment I added. It is my second response, you may be looking at it from your inbox. maybe if you can go to the original response you will see the attachment.Attachment.JPG