Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a load scripts that first takes a start date and end date from sheet1 of the qlikview dashboard and loads the data from QVD files accordingly.
SEARCH:
LOAD *
FROM
$(vFilename)(qvd) Where cdate>= $(vStartDate) and cdate<=$(vEndDate);
where vStartDate and vEndDate are variables set using a calender object in sheet1 of the dashboard.
There is a Button named 'Go' that has Action = Reload. When i click the button, the reloading happens but never stops. But instead, i press Ctrl+R, then reloading happens properly.....
Help me out.
Hi Arjun
Thanks for this. It does work. Looks like there is a bug in Qlivkview.
I'd like to set and unset this option via a macro something like:
set up = ActiveDocument.GetApplication.GetUserPreferences
up.XXX = true
ActiveDocument.GetApplication.SetUserPreferences up
Anyone know what XXX should be? I've looked in the QV API guide, but I can't seem to find it.
Garry
Hi Garry and Arjun,
Good you have solved that but No it's not a Bug it's an option available for developers for an ease where you can verify the data rows/tables are loaded correctly. if you make that Selection unchecked then while reloading you can can Monitor all your tables are loaded correctly and if you reload the Application through Server/Publisher still it will not through any error.
but creating a Button will halt at that stage so for your Scenario you have to Check it compulsory.
Hope I am Clear
Hi,
In my case was a precedent temp table not being dropped and causing extensive synthetic keys.