Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
pjpkumar26
Contributor III
Contributor III

Number Format

Hello All,

I have created the belwo function and it works as expected:

sum(aggr(sum(aggr(Count(distinct[Emp]),[Date],[Dep],[Com])),[We]))/
count(total<[We]>distinct[Date])

I get the value 1267,000,0

I need to show only 1267 in the sheet 

I tried format number but it din't work

Any suggestions please?

Thanks,

Kumar

1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Can you take a look at the other post [1], where this use case scenario is already discussed?

 

Note: The suggested solution is to use Num(EXPRESSION) and custom formatting if needed like: Num(EXPRESSION, 'CUSTOM_FORMATTING'). Further details are posted in the post.

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Formatting/m-p/1981965#M214208

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

3 Replies
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Can you take a look at the other post [1], where this use case scenario is already discussed?

 

Note: The suggested solution is to use Num(EXPRESSION) and custom formatting if needed like: Num(EXPRESSION, 'CUSTOM_FORMATTING'). Further details are posted in the post.

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Formatting/m-p/1981965#M214208

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
pjpkumar26
Contributor III
Contributor III
Author

sorry re-posted again by mistake

Andrei_Cusnir
Specialist
Specialist

Hello,

 

No worries. I just mentioned it here, just in case someone else was looking for a similar solution and have found this post, instead of the other one 😊

Help users find answers! Don't forget to mark a solution that worked for you! 🙂