Format numbers in chart to display decimals differently

Tue, 30 Mar 2010 21:03:42 GMT

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

Format numbers in chart to display decimals differently

johnw — Tue, 30 Mar 2010 21:29:32 GMT

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.

topic Format numbers in chart to display decimals differently in QlikView

Format numbers in chart to display decimals differently

Format numbers in chart to display decimals differently