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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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