Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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    

0 Replies