2 Replies Latest reply: Aug 6, 2012 4:03 AM by Claudia Zwick

# Straight Table Problem

Hi Community,

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.

• ###### Re: Straight Table Problem

This is coming so i didn't find any problem in this,

Check out the app..

Hope it helps!!!

• ###### Re: Straight Table Problem

Hi,

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.

Regards Vicky