topic Automatically adding values in Pivot Table in QlikView

Automatically adding values in Pivot Table

Fri, 27 Aug 2010 17:04:26 GMT

I have attached a sample app and this is probably a very simple fix, but I am new to QV and haven't been able to figure it out. Normally when I add a column to the pivot table it will automatically add the values from 2 different rows. Well for some reason it is not doing this. If I select multiple periods it is not adding the 2 rows together. For instance if I select period 4 the volume allowance column has data and if I select period 5 the data is there, but if I select both of those periods simultaneously it shows "-" (NULL). What have I done wrong.

Automatically adding values in Pivot Table

Fri, 27 Aug 2010 17:12:04 GMT

In your expression you must use Sum(VolumeAllowance) instead of VolumeAllowance.

Is it normal that your data are missing except for CC=1713 ?

jjj

Automatically adding values in Pivot Table

Fri, 27 Aug 2010 17:21:18 GMT

Thanks...I thought that. I modified the query to only show that specific CC for the sample.