topic Partial reload problem in QlikView

Partial reload problem

Fri, 23 Oct 2009 22:39:08 GMT

Hi,

there's non-clear moment when I use "ActiveDocument.PartialRelod" in macros:

I've load two tables - one of them from Oracle database (big, incremental load option) table, another "autogenerate" table (small, with "replace" prefix on load), also there's action (macros, Variable Event Trigger, on input) and chart. Well, when variable's value's changed data in small table correctly change too, but chart doesn't react to change data?

Partial reload problem

Fri, 23 Oct 2009 23:43:39 GMT

Whether both the QV tables loaded are having some common joins/mappings? In such cases I have also faced some reloading issues. Are you getting the Table Joins intact after partial reload? Is the chart uses data from both?

--Arun

Partial reload problem

Sat, 24 Oct 2009 00:12:36 GMT

Yes, Arun, you're rigth - there's join between these tables ( "intervalmatch" type ). I'm not sure that I understand correctly ( sorry for my poor english 🙂 ) your second question - but my answer is - yes, I put join after both tables:

table1: sql select ... -> table2: replace load ... autogenerate -> ... intervalmatch ...

and chart uses data from both tables.

I use QlikView Personal Edition 4Win, Ver.9.00.7119.4 and face with another collision - PartialReload method ( when I use "replace" without "only" ) add new data to table, but don't clear initial data ... I can't understand how it work.

Partial reload problem

Sat, 24 Oct 2009 02:11:20 GMT

Probably that will be the problem. As the QV table is dropped and re-created internally during the partial re-load, replace should apply for all mapped/intervalue matched join sources to the table also (in your example Table2:) to recreate the table proprly. Is there a possibility to avoid the intrvalmatch and leave the table2: independent of interval join?

'Only' qualifier will not recreate the QV table during full load. So for the initial load, comment this and try.. For further reloads, you can use this.

--Arun

Partial reload problem

Mon, 26 Oct 2009 15:37:15 GMT

Thanks for answer again, Arun.

About possibility to avoid "intervalmatch" link between 2 tables - of course I can drop link, but how I get result dataset (for chart)? May be there's another way to make a solution for my task (I have the table in Oracle database which contain some information about user's session: start time, finish time, program, user id, session id, etc. And I have to show count of sessions group by program on the same timestamp (15 min intervals of the same day) ).

Regards, Dmitry

Partial reload problem

Tue, 27 Oct 2009 00:55:32 GMT

Well, I can't explain how is it works - but it works!

Before:



inner join (LogOnOff)
intervalmatch(DateTimeStamp) load DDATE_LOGON, DDATE_LOGOFF resident LogOnOff;

Now:



replace
//inner join (LogOnOff)
intervalmatch(DateTimeStamp) load DDATE_LOGON, DDATE_LOGOFF resident LogOnOff;