Discussion board where members can get started with Qlik Sense.
I need to format the value of expressions in a pivot table conditionally. I.e if the expression returns a value >100, I want to show 5 digits after decimal. Vice versa, it shows 6 digits.
I see that the Number formatting in Properties doesn't have option for this. Does anyone have any idea?
Please try below expression:
Note : Replace Profit with you actual field.
You could try format the expression output as follow:
I tried this but it doesn't work. I guess perhaps because of the format. However I cannot post the formula here due to confidentiality. Can I have your email?
Hi Thiago, I applied your solution but it didn't work.
Could you please. post your expression?
Cannot post it here due to confidentiality. If possible can I have your email?