Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jayz1489
Contributor II
Contributor II

Store each month data but data is updated in the excel sheet daily.

Hi,

I have to record the count of the licenses acquired each month. However, every time a report is fetched from the license portal, it gives the list of current licenses in use without a date.

I have reports fetched over a year on the first week of every month.

Now I have to create a dashboard which shows The count of licenses every month and monthly comparison over time (increase and decrease every month).

 

I am unable to figure out how to go with the data source because there are too many data files. 

I don't see it as a good approach to upload a file every month.

Can someone please help me with the approach?

 

Thanks

Labels (4)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

Do you have all files and are they stamped with a date? So can you differentiate between March and April?

Jordy

Climber

Work smarter, not harder