Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
sorry re-posted again by mistake
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 😊