Week by Week Total Volume

[Manoj_2508]

Hello Qlik Experts.!

I am seeking an urgent help on my new requirement.

I want to calculate Every week total volume along with every day volume. In every week Total volume my data should not cumulative. 

Please see the below screenshot:

I achieved it from script side but I want to achieve from chart level cause I don't want to disturb my data model.

Please help me from the above issue.!

Thanks in Advance.!!

@marksouzacosta  @Lech_Miszkiewicz @Antoine04 @lennart_mo @MatheusC @bakedbean : Please help us to get the every week total.

[Parthiban · Accepted solution]

Hi,

Pls try this Sum(total<Delivery Week> Every Day volume)

[Manoj_2508]

Thanks @Parthiban . I tried but it didn't work out. 

[Lech_Miszkiewicz]

@Manoj_2508 what doesnt work? Share the result so we can comment. Maybe you are just using it wrong as the measure needs to be in right context in the chart/table object

Sum(total<[Delivery Week]> [Every Day volume])

The above expression will work as long as it used correctly meaning the fields in expression are actually fields from your data model (not some calculated dimensions!!!)

Simple Ctrl+Q+Q (Ctrl+0+0) example below which shows you that the principles of the formul work exactly as we said.