I am using direct query functionality in qlik sense,below is the example table .After loading the tables while i am creating visual KPI (
sum(Sales) ) it is trowing error database connection failed.Any suggestions.
From Test table;
Could you please post your real script? which version of Qlik Sense are you using?
can you check the access for the database. your sample script looks fine
Retrieving data ...