Switch Between Full Load And Incremental Load

[#1]

All,

I have small Qlikview Project. In my Script Editor window i made two tab one for Full Data Load And other for Incremental Load.

How I Switch between Full load and incremental load tabs in reloading time...?

Or Is there any other way to perform Full data load or Incremental load based on end user action..?

Regards,

Faisal

[avinashelite]

Hi Faisal,

first identify Based on which condition you want the incremental and full load.

Then use conditions functions like If and verify the condition, if it satisfy then direct it to  increment or full load

[#3]

Hi Avinash,

Thanks for the reply.

There is two options

1.     Initial load will be full load and after that each reloading time 'incremental load' have to perform

2.     End user can take decision whether he want full data load or Incremental load in dynamic way

Regards,

Faisal M A

[avinashelite]

I think this is not possible!! because how will you get the user input every time??? and it will be a manual work to get the user selection and reading that in the script is very tedious.

so you have to decide whether you want a full reload or only incremental load and design the same rest of the schedule reloading task will be taken care by QMC.

[#5]

Then can you please explain, how will perform the first option.

Also Is there any way to perform second option using button or some thing

Like below

Regards,

Faisal

[avinashelite]

Ok see, in the button background you need to set a variable in the front end.

say the variable name vReload and set value using the action (see in the button properties) to Full load or Incremet

then in the script try like this:

let vReload_parameter=$(vReload);

if vReload_parameter='Full load'

then

your full reload script

....

else

your incremental reload script

[#7]

Ok I Understand Thanks.

But one more question,

How we know in Reloading time, if it is first reload

Regards,

Faisal

[jagan]

Hi,

Check this link, hope it help syou.

Getting Input while reloading in Qlikview

Temp:

LOAD

Input('Enter Load Type', 'Input box') AS InputValue

AutoGenerate 1;

LET vLoadType = Peek('InputValue');

DROP TABLE Temp;

IF vLoadType = 'Full' THEN

     // Your Full Load script goes here

ELSE

     // Your Incremental Load script goes here

ENDIF;

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If user enter Full, then Full load is performed otherwise incremental load is performed.

Regards,

Jagan.

[#10]

Hi Jagan,

When I open the link following error is coming

Also can you please explain more about Full Load and Incremental load.

What I want is First load will Full Load after all load would be Incremental load.

Which condition will give without input box or button...?

Regards,

Faisal M A