Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table monthly volume with YTD volume

Hi,

I have a Qliksense overview of monthly volumes per region.

I have created a table with measure Sum([#Quantity]) per region, but want to add a second column with total volume year to date....

How can I do that?

3 Replies
OmarBenSalem
Partner
Partner

Just choose a dynamic table;

Keep your measure, and add a line 'year":

Capture.PNG

Not applicable
Author

thanks, how do you create a dynamic table?

OmarBenSalem
Partner
Partner

Capture.PNG

Youc an just drag it on top of your current table and convert it.

Your simple table will be converted to a dynamic one with the same dimenions/measures.
Then add a line 'year' and put it above your month dimension:

Capture.PNG

Please, don't forget to mark as helpful the answers that helped you (under actions) and as correct the correct answer to close the thread and thus help the community in search for informations