Format numbers in chart to display decimals differently
I have data in my system that shows as "2.1" and "2.10" and both are completely different values. In my chart, I can only make it display as either "2.1" or "2.10" and then it combines the two values into one line. I've tried Mixed, Number, Integer, and Fixed to; all with 2 and 3 decimal places to no avail. Does anyone have suggestions how I can show these different values correctly and on two separate lines? thanks, Ryan
I can't read the .doc. I might not have a recent enough version of Word.
Trying to guess without seeing it, you may need to read your data in as a dual() value with a text equivalent. Something like this:
dual(text(MyNumber),MyNumber) as MyNumber
I suspect that QlikView will then recognize that 2.1 and 2.10 are distinct, even if they have the same underlying numeric value. In a completely numeric chart, they'll likely still combine into one data point. But in a chart that can show text, such as if you use MyNumber as a dimension, they'll likely separate into two values.
