Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there a way that we can write back from Qlikview Dashboard to database?
And is there a way to pull data from Database to Qlikview realtime?
Eg., when I open the Qlikview Dashboard from Access point I want fresh data to be loaded always
Thanks,
John
Is there a way that we can write back from Qlikview Dashboard to database?
there are some discussions in the community
Write Back to Database via ETL process (using CSV or XML)
And is there a way to pull data from Database to Qlikview realtime?
Thanks.
I am just trying to execute an direct discovery query as below but it throws error as "Line is not valid"
I am using Qlikview version 11.20
SET DirectConnectionMax=10;
REVENUE:
DIRECT SELECT
pl_date,
user_name,
daily_pl
FROM pl_signoff;
from help the syntax seems
DIRECT QUERY
DIMENSION Dim1, Dim2
MEASURE X, Y
FROM TableName;
An useful doc on direct query
Syntax error but the query looks good to me. Is there anything else I need to enable in Qlikview in order Direct discovery to work?
I believe direct query works for Sybase database
REVENUE:
DIRECT QUERY
DIMENSION
pl_date, user_name
MEASURE
daily_pl
FROM spotfire..pl_signoff;
first try without direct query
to check the connection with sybase works
sql select ..... from spotfire.....;
Yep, SQL Select works..
Works for SQL server though
DIRECT QUERY
DIMENSION
EXCHANGE_RT
FROM rbadb_v1.dbo.GLOBAL_CURRENCY_EXCH_RATE;