topic Re: decimal Numbers and Rounding... in QlikView

decimal Numbers and Rounding...

leocattqv — Thu, 08 Mar 2018 21:46:10 GMT

All, I have been lurking on the boards trying to get an answer to this and Im just not getting it I suppose.

I have a table that I am getting the PValue from. this is from Excel.

Week	Field 1	Field 2	Pvalue
Week 1	2765	48	0.01736
Week 2	3541	50	0.01412
Week 3	11887	73	0.006141
Week 4	6549	82	0.012521
Week 5	5511	67	0.012158
Week 6	6869	61	0.00888
Week 7	4193	80	0.019079
Week 8	4295	71	0.016531
Week 9	4052	84	0.020731

When I put the same data into Qlik, (inline table - for testing purpose) I get this

Week	Field 1	Field 2	PValue
	616	49662	1
1	48	2765	1
2	50	3541	1
3	73	11887	1
4	82	6549	1
5	67	5511	1
6	61	6869	1
7	80	4193	1
8	71	4295	1
9	84	4052	1

Again, I am reading the boards and Im confused as there is talk of making the calcs before the data goes to qlik? this should be a simple thing shouldnt it?

Any help would be appreciated.

thanks

-L

Re: decimal Numbers and Rounding...

yujiyamane — Fri, 09 Mar 2018 00:50:24 GMT

Hi Leo,

Does the inline load look like as below?

LOAD * INLINE [

Week, Field 1, Field 2, Pvalue

Week 1, 2765, 48, 0.01736

Week 2, 3541, 50, 0.01412

Week 3, 11887, 73, 0.006141

Week 4, 6549, 82, 0.012521

Week 5, 5511, 67, 0.012158

Week 6, 6869, 61, 0.00888

Week 7, 4193, 80, 0.019079

Week 8, 4295, 71, 0.016531

Week 9, 4052, 84, 0.020731

];

It works fine to me as per below. Please find the attached qvw for details.

Re: decimal Numbers and Rounding...

leocattqv — Fri, 09 Mar 2018 12:19:47 GMT

thank you for your time Yamane,

My load doesnt include Pvalue - I need to be able to calculate in Qlik

Data:

Load * Inline

[

Week,ShipQty,CompQty

1,2765, 48

2,3541, 50

3,11887, 73

4,6549, 82

5,5511, 67

6,6869, 61

7,4193, 80

8,4295, 71

9,4052, 84

];

Re: decimal Numbers and Rounding...

yujiyamane — Sun, 11 Mar 2018 23:10:37 GMT

Thanks Leo, Try below query. I have attached the sample application as well.

Data:

Load *,CompQty/ShipQty as Pvalue Inline

[

Week,ShipQty,CompQty

1,2765, 48

2,3541, 50

3,11887, 73

4,6549, 82

5,5511, 67

6,6869, 61

7,4193, 80

8,4295, 71

9,4052, 84

];

Re: decimal Numbers and Rounding...

vishsaggi — Mon, 12 Mar 2018 03:17:37 GMT

Can you share your complete script where you are getting this 1 for Pvalue. Did you check the Number tab in your chart properties of your straight table. ?