Stopp automatic multiplikation if I set the percentage sign
Hello together,
I try to customise a master measure over the “Number formating” option.
The problem is when change it to custom and I ad the percentage sign to the format pattern,
Qlik mulitpies the given vaule with 100. Yes I could divide this value by 100, but I am using the master massures for further calculations, therefore I don’t want to chage the value.
Is there an other option to get a percentage sing in the value without doing the math befroehand?
Displaying in % format just affects the display, not the underlying value. If you have a value of 0.1 and choose to display it as a percentage, it will show 10%, if you choose auto or display as number, it will show 0.1.
But the value is still 0.1 in both cases, so I don't think you need to do anything.
If you add 5 to the value, it will still be 5.1, irrespective of whether you displayed the 0.1 as a percentage or not.
But if you really want to just add a percentage sign to your value, just add it in the measure definition, so [Your Value] becomes [Your Value] & '%'
I don't think there is anyway you can suppress the behavior. A couple of options.
1. For this chart, use the Measure in an expression and divide by 100. Then you would not be updating the Master Measure. For example, if your Measure name is "Avg Discount":
"Avg Discount" / 100
2. If you always want to display the % sign when you display this measure, you can code the measure as a Dual() and hardcode the % into the string and select "Measure Expresssion" as the Measure Formatting.
Displaying in % format just affects the display, not the underlying value. If you have a value of 0.1 and choose to display it as a percentage, it will show 10%, if you choose auto or display as number, it will show 0.1.
But the value is still 0.1 in both cases, so I don't think you need to do anything.
If you add 5 to the value, it will still be 5.1, irrespective of whether you displayed the 0.1 as a percentage or not.
But if you really want to just add a percentage sign to your value, just add it in the measure definition, so [Your Value] becomes [Your Value] & '%'
I don't think there is anyway you can suppress the behavior. A couple of options.
1. For this chart, use the Measure in an expression and divide by 100. Then you would not be updating the Master Measure. For example, if your Measure name is "Avg Discount":
"Avg Discount" / 100
2. If you always want to display the % sign when you display this measure, you can code the measure as a Dual() and hardcode the % into the string and select "Measure Expresssion" as the Measure Formatting.
