Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Champion III
Partner - Champion III

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