Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

eddysunn
New Contributor III

Monthly Data with Weekly Incremental Update

Hi Everyone,

Need you ideas and help on below.

I have a weekly updated table. And there is a field called _loadedOn which captures the date when the data was, well, loaded.

Now the task is to create a bar chart, where the dimension should be months and measure should be the sum of Sales.

when i do:

          MonthName(_loadedOn) as dimension and

          sum(Sales)                           as the measure

The bar chart shows the months as it should, but the measure sums up all weeks Sales together. In my case I would like to have the last week's data of a particular month to be presented in the graph.


What approach should I follow, any ideas?

Thanks all.

Edil    

Community Browser