Hi, I am in the process of designing a qlikview+web+db solution. I will explain it.
I have a qv dashboard with a pivot table and one of the expressions is a link to a web page, so i click on the link and the web page is passed some parameters about the row in Pivot table. Based on this some inputs are received on the web page and submitted to the database. Now i want QV to know the status of the update.
for e.g. if my original pivot table was based on a query like....
select ac_no from db_table where update_flag=0;
and now once after the db commit (say for a particular account update_flag was updated to 1, so it should not be retrieved when the screen is opened again that would be great). I thought of EDX calls, but again that would refresh the whole QVW that will take a long time. Thought of a DIRECT DISCOVERY but not sure how to trigger the query after the web/database handshake is complete.
My QVW is based on a host of QVDs and i want just this screen to be real time, all others can still rely on the QVDs refreshed overnight.
Any valuable suggestions would be great.
Thanks,
Ram
