topic Reload based on selection in QlikView

Reload based on selection

Thu, 20 Aug 2009 16:12:08 GMT

Hi *,

I'm trying to reload data from a certain table (Sales_RTY) based on the selection I made in the application.
e.g. I select years 2009 and 2008, only this years should be reloaded. Has anyone some hints for my what's the best practice to handle this?

Sales_RTY looks like this:

Sales_RTY:
Sales_id, Sales_amt, Sales_Date, Sales_cst,....

Thanks in advance

elzo

Reload based on selection

ipauldur — Thu, 20 Aug 2009 16:32:45 GMT

Hi elzo,

You can create variable and assign the selected field value into that variable.

Then, you can use that variable to define the "where" condition of load statement.

Hope this will help,

Regards,

Durai.

Reload based on selection

Fri, 21 Aug 2009 19:28:40 GMT

Hi Durai,

thanks for your help, unfortunatly I didn't get it running?

how can I assign multiple selections (eg. years: 2007,2008,2009) to a variable?

I used FROM Sales WHERE year(Sales.DATE) Like '$(v_reload_years)' in script. This is working as long as I assignt a value manually to my variable

e.g. Set v_reload_years = '2008';

Tried it with creating a variable via document settings and variable value = year (field) . unfortunately this didn't work.

I got the values to my variable with: =GetFieldSelections(Year). Unfortunaltey this isn't working for reload. Any idea?

Thanks

Reload based on selection

bismart — Fri, 21 Aug 2009 20:24:58 GMT

1. Make required selections in application

2. File... Reduce Data... Keep Possible Values

Application will reload only data that meets your selections.