Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
senpradip007
Specialist III
Specialist 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
rajni_batra
Specialist
Specialist

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

Check out the app..

Hope it helps!!!

View solution in original post

2 Replies
rajni_batra
Specialist
Specialist

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

Check out the app..

Hope it helps!!!

Not applicable

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