Incremental Load at the Dashboard Layer

[owais_sarwar]

Hello All,

I am stuck in a specific thing. I need to make the presentation layer dynamic as if i want to update the Qlikview Dashboard just for the current month and i want the history data as it is in the Fact table and dashboard layer. I heard that incremental load just works on the extraction phase doesn't work on the presentation layer.

Moreover, another bug in the model is that it if i want to clean the data for the current month on Qlikview, I have to first merge in in to the containing year table and then again clean the whole year by the addition of each upcoming Month's data. I want to just clean the data of the current month and then merge it to the Qvd of the containing year.

It would be great and highly appreciable if anyone can promptly help me out

Regards,

Owais Sarwar