Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have value in a QVD file e.g
cost | quantity | total |
800 | 2 | 1600 |
1600 | 2 | 3200 |
3570 | 2 | 7140 |
4800 | 2 | 9600 |
4000 | 2 | 8000 |
5600 | 2 | 11200 |
40740 |
However I am getting this when I use the sum function
cost | quantity | total |
800 | 2 | 1600 |
1600 | 2 | 6400 |
3570 | 2 | 14,280 |
4800 | 2 | 24000 |
4000 | 2 | 19200 |
5600 | 2 | 11200 |
177480 |
Apologies I am new to qlik
This is messing up my graphs
Here is the calculated field
sum(<[field1=,[field2]=, [field3]=[field4]-=[field5]=,[field6]=,[field7]=,[field8]=,[field9]=,[field10]=,[field11]=,[field12]=,[field13]=>}[Snapshot Quantity at Location]*[Snapshot Cost])
I could not see any issue while summing. But, can you explain me more on what you are trying?
Hi @norbook_dev
Reason Might be, in ur data model, if you are doing any join with ur fact table, it cause the data duplicated.
Can you check, ur qvd record count is similar to ur data model table count.
Yea sum works ok when I have the table stand alone but when I add in sum it throws off sums
I think maybe Mayil Vahanan R may have a point about the fact table. We are linking this up.