topic Re: Reload part of the script using buttons in QlikView

Reload part of the script using buttons

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am having 10 tables in script ,each schema having 5 tables ,so I have 2 data models in a script .

My requirement is I want to split 2 different schemas and also want to 2 buttons in UI. when I click on button 1 then schema 1 should get reload and when I click on button 2 schema 2 should reload instead of all tables.

Please suggest

Re: Reload part of the script using buttons

sunny_talwar — Wed, 06 Apr 2016 09:48:59 GMT

May be this:

IF $(vVar1) = 1 then

Table1:

LOAD * Inline [

Dim1, Value1

A, 600

];

ELSEIF $(vVar1) = 0 then

Table2:

LOAD * Inline [

Dim1, Value2

B, 800

];

ENDIF

But once you reload one table, the other will go away. Are you wanting to just update one and leave the other one intact? If that's what is needed, may be you can do it will partial reload

Re: Reload part of the script using buttons

sunny_talwar — Wed, 06 Apr 2016 09:52:25 GMT

Partial Reload version:

IF $(vVar1) = 1 then

Table1:

Replace

LOAD * Inline [

Dim1, Value1

A, 100

];

ELSEIF $(vVar1) = 0 then

Table2:

Replace

LOAD * Inline [

Dim1, Value2

B, 200

];

ENDIF

Re: Reload part of the script using buttons

Wed, 06 Apr 2016 10:10:32 GMT

Create two separate application for each schema.

Now add button in each application.
Open the button properties---> add the action 'Reload'.
So when you click the button the application gets reloaded.

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 05:51:05 GMT

Sourav already I am doing the same way ,having 2 separate QVW files but I want both in the single one.

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 05:52:50 GMT

Hi Sunny,

Then how can I call those in buttons ?

If I select button1 then script1 should reload and if I click on button2 script 2 should get reload.

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 06:14:11 GMT

I am using above code in my script .

Took 2 buttons which are B1 and B2.

B1 Properties:

SetVariable

Value =vVar1

Variable=vVar1

Relaod

B2 Properties:

SetVariable

Value =vVar1

Variable=vVar1

Relaod

When I am clicking on B1 or B2 only executing Table 1 .

If I click on B1 then Table1 should execute and if I click on B2 table2 should execute.

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 06:20:22 GMT

Not getting the Table2 in datamodel.

Re: Reload part of the script using buttons

sunny_talwar — Thu, 07 Apr 2016 09:39:24 GMT

Which of the two solution have you been using? and what is the expectation? One of the two tables stays and the other one goes away or you need that one stays and other gets updated?

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 10:32:38 GMT

I am using first solution.

Both models should be there in project only based on the button event they should be reload.

One should be there and other need to get reloaded based on the button click.

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 10:46:47 GMT

Using this solution :

IF $(vVar1) = 1 then

Table1:

LOAD * Inline [

Dim1, Value1

A, 600

];

ELSEIF $(vVar1) = 0 then

Table2:

LOAD * Inline [

Dim1, Value2

B, 800

];

ENDIF

Re: Reload part of the script using buttons

sunny_talwar — Thu, 07 Apr 2016 10:55:47 GMT

In that case, I would suggest you to explore the second option

Re: Reload part of the script using buttons

Thu, 07 Apr 2016 11:30:11 GMT

Tried second solution also, there also I can see only one table at a time.

Re: Reload part of the script using buttons

sunny_talwar — Thu, 07 Apr 2016 12:13:37 GMT

These are the steps you need to follow:

1) LOAD all data without any if statements

Table1:

Replace

LOAD * Inline [

Dim1, Value1

A, 100

];

Table2:

Replace

LOAD * Inline [

Dim1, Value2

B, 200

];

2) Now set up your front end with the buttons and other objects and add if statements back in the script. NOTE: Make sure your Reload action as Partial reload checked. Also note to change the data to see the change on the front end (see the new numbers in red)

IF $(vVar1) = 1 then

Table1:

Replace

LOAD * Inline [

Dim1, Value1

A, 100 200

];

ELSEIF $(vVar1) = 0 then

Table2:

Replace

LOAD * Inline [

Dim1, Value2

B, 200 400

];

ENDIF

3) Select one button at a time and see how the reload changes just one data set at a time