Help with Straight table

Anonymous — Thu, 06 Aug 2015 20:22:17 GMT

hi guys

I am attaching a qvw here which has many calculations,i am finding a very strange thing here or maybe i just never experienced it before.

there are 2 columns named Qty here one is in dimension which is just qty and other is sum(qty) in expressions.I verified this column and the column qty which is in expressions as sum(qty) seems to be correct when matched with sources.All my other values also are matching such as Primary frt,alloc Primary frt,sec frt,alloc sec frt.

Now here is the strange thing as soon as i remove the Qty column(because I dont need it anymore) from dimensions which is just qty not the sum all the other values change and these are no more correct.

One more thing Primary frt is using the qty and it is coming correct even after removing the qty column and Alloc primary frt is using primary frt to get the value.if primary frt is correct so should Alloc prim frt.

And why is this even happening after removing the qty column?

Any suggestions or help ?

Urgent solution required.

Re: Help with Straight table

Anonymous — Thu, 06 Aug 2015 20:23:37 GMT

primary frt - 2517676

alloc primar - 5701874

sec frt - 7885729

alloc sec frt- 2516613

whs cost - 1931742

alloc whs cos- 1197883

liasion - 15561004

alloc lc - 12298648

these are the correct values when year 2015 and month Apr is selected...

topic Help with Straight table in QlikView

Help with Straight table

Re: Help with Straight table