decimal Numbers and Rounding... - Qlik Community

leocattqv · ‎2018-03-08

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

yujiyamane · ‎2018-03-08

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.

leocattqv · ‎2018-03-09

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

];

yujiyamane · ‎2018-03-11

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