Discussion board where members can get started with QlikView.
I'm new in qlikview and need a help regarding straight table.
I have two columns named "Value" and "Qty", and the 3rd column shows the result of "Value" / "Qty".
Now the problem is as follows:
suppose Value = 46846298.67 and Qty = 469013.34 , so the result should come 99.88 inspite of 0.9988 without multiplying with 100 or without checking the Show in Percent at Number tab
For details pls check the attachment.
Please help me.... thanx in advance..
Go to Solution.
This is coming so i didn't find any problem in this,
Check out the app..
Hope it helps!!!
Could it be possible, that you have a false expression?
Your Value has 8 numbers before the comma and the Qty only 6. So the table calculates true.
I suggest, that you want to have the percantage of Qty to Value, then you become 0,010 without multiplying with 100 or checking the box in Number Tab.