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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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 - Champion II
Partner - Champion II

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 - Champion II
Partner - Champion II

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