Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
coolguy123
Contributor II
Contributor II
‎2019-11-19 03:56 PM

Datasource and automation

hi 

 

a question on qlik sense 

 

I have a folder where I will be adding csv to daily Let me call it abc_010119 abc_020119

 this will happen on a daily basis

also contains some other sheets for lookups 

i setup qlik sense  via data load editor some scripts to load each one sheet e.g. today and lookups 

 

i also creates a dashboard with some tables kpi etc 

i need help on:

1. how to I automate this so everyday qlik sense produces a dashboard for the new daily csv 

2. how can I automate qlik sense to only give me the data from the dashboard table 

 

thank

 

595 Views
1 Reply
vunguyenq89
Creator III
Creator III
‎2019-11-20 04:23 AM

Hi,

To load latest csv file from a folder, see this discussion https://community.qlik.com/t5/QlikView-Scripting/How-to-load-latest-file-to-load-script/td-p/123873

To automate app reload everyday, you can set up a reload task scheduled trigger. This feature is only available  in Qlik Sense Enterprise or Qlik Sense Business. Instruction at https://www.youtube.com/watch?v=smCXRprs-YU

Regarding question (2), could you clarify what you need by "only give me the data from the dashboard table" ?

BR,

Vu Nguyen

569 Views