topic Re: Straight Table Problem in QlikView

Straight Table Problem

senpradip007 — Mon, 06 Aug 2012 07:50:11 GMT

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.

Please help me.... thanx in advance..

Re: Straight Table Problem

rajni_batra — Mon, 06 Aug 2012 07:59:05 GMT

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

Check out the app..

Hope it helps!!!

Re: Straight Table Problem

Mon, 06 Aug 2012 08:03:24 GMT

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