Number Format

[pjpkumar26]

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

[Andrei_Cusnir · Accepted solution]

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

[pjpkumar26]

sorry re-posted again by mistake

[Andrei_Cusnir]

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 😊