Reload based on selection

[#1]

Hi,

I have a requirement where I need to build a sheet which allows:

1) selection of two dates

2) based on the dates we need to retrieve an associated value

3) the associated value will be passed to a variable

4) the variable is used in the load script

5) reload the data to show updated results

Please let me know if this is possible?

thanks

[tresesco]

Only interactive command is Input statement to accept input from user during load.

[#3]

ok so is there a way to get a corresponding value for the current date selection?

I am already setting the dates into two variables.

• I need to retrieve the corresponding attribute value
• once I get this value, I can then set it to a variable
• and use the variable in the load script which will only work if I reload

So the difficult part is getting the value corresponding to the date. Is there a set analysis option that I can use?

[SergeyMak]

Hi

Can you share an app example to answer your second part of question?

I think you can save your "associated value" into text file and then use it in load script.

[tresesco]

Look at the attached sample qvw. Do you want something like that?

[Anonymous]

I think its possible ....

That data can be loaded on basis of seletion of dates..

Can you please upload a sample app, I can show you

[#7]

Sergey,

I think the second part can be implemented using a variable in the load script like :

LOAD KEY,

     Attribute1,

     Attribute2

FROM

[..\data.xlsx]

(ooxml, embedded labels, table is DATA)

WHERE KEY=vRuntime;

On the sheet you can have a button that has two actions:

1. Set the variable value for vRuntime

2. Reload

This should solve the purpose.

[sujeetsingh]

trsco you are having the names of the experts of community .

Well Tresco i want to know the vay of deploying this sample through server.

How can we configure tasks to handle it.

I went through number of EDX documents on community but not able to implement it.

If possible can you explain in simple words the steps to deploy this.

[#9]

Nitin,

We are currently using personal edition of Qlikview @work hence I won't be able to open examples etc.

Is there an option like using: where clause in the expression?

The scenario is:

1. I have two calendar objects on the sheet

2. Users can select start and end dates on the sheet

3. The related charts have to be updated with data from both dates. The catch is that we need to compare the statuses of records on both dates and report difference counts.

[Anonymous]

PFA