topic Reload based on selection in QlikView

Reload based on selection

Wed, 04 Jun 2014 04:07:23 GMT

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

Re: Reload based on selection

tresB — Wed, 04 Jun 2014 04:32:27 GMT

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

Re: Reload based on selection

Wed, 04 Jun 2014 04:54:49 GMT

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?

Re: Reload based on selection

SergeyMak — Wed, 04 Jun 2014 05:27:04 GMT

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.

Re: Re: Reload based on selection

tresB — Wed, 04 Jun 2014 05:32:47 GMT

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

Re: Reload based on selection

Anonymous — Wed, 04 Jun 2014 05:37:43 GMT

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

Re: Reload based on selection

Wed, 04 Jun 2014 05:39:51 GMT

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.

Re: Reload based on selection

sujeetsingh — Wed, 04 Jun 2014 05:41:01 GMT

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.

Re: Reload based on selection

Wed, 04 Jun 2014 05:46:07 GMT

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.

Re: Re: Reload based on selection

Anonymous — Wed, 04 Jun 2014 05:53:09 GMT

PFA

Re: Re: Reload based on selection

tresB — Wed, 04 Jun 2014 05:58:43 GMT

See the screenshots attached.

Re: Reload based on selection

Wed, 04 Jun 2014 06:09:35 GMT

Thanks tresesco! That does help but I am still not able to figure the complete puzzle.

I still need to get the value associated to the two dates. Sorry for being too naive but I am just one week old in Qlikview terms.

Re: Re: Reload based on selection

tresB — Wed, 04 Jun 2014 06:16:00 GMT

In that case, you have to similarly deal with two variables and use them in the script, like:

Load

where Date>=$(vStartDate) and Date<= $(vEndDate);

Re: Reload based on selection

hannan_t — Mon, 11 Aug 2014 12:49:22 GMT

In my opinion, use an expression in load script variable e.g

vLoadScript = Sum({<Date={'$(vLastday)'}, Date={'$(vToday)'}>}Amont)

Make variables for the dates you want to select and pass it to your expression through set analysis.

Re: Reload based on selection

Mon, 11 Aug 2014 22:13:12 GMT

I was able to solve this with Manish's help ....post can be found here http://community.qlik.com/thread/124995