Partial reload problem

[#1]

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?

[#2]

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

[#3]

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.

[#4 · Accepted solution]

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

[#5]

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

[#6]

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;