Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Automatically adding values in Pivot Table

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

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

jjj

Not applicable
Author

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