Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to create a calendar and history table

Hello guys,

I need some help with the following case; I am building a dashboard for a TOPdesk module called Configuration management. This dashboard doesn't have much information on it, Create and ChangeDates for Hardware and Software, ID's and names of the objects.

The KPI I would like to create as a report in nPrinting is:

All objects that are changed in the previous period (=month) in a table that contains the last 12 months of this data. We have learned that we need to build a historical table but I'm not sure how to do this.

Can someone help me with this? In the attachment you find the QVW document. !

1 Reply
Gysbert_Wassenaar

It sounds like you want to implement incremental loading. If so, perhaps this blog post helps: Incremental Load using Qlikview Components | Qlikview Cookbook


talk is cheap, supply exceeds demand