Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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