Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

senpradip007
Valued Contributor III

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.

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

1 Solution

Accepted Solutions
Highlighted
rajni_batra
Valued Contributor

Re: Straight Table Problem

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

Check out the app..

Hope it helps!!!

2 Replies
Highlighted
rajni_batra
Valued Contributor

Re: Straight Table Problem

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

Check out the app..

Hope it helps!!!

Not applicable

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

Community Browser