topic Re: Load Fields from Qvd File Based On Selections in QlikView

Load Fields from Qvd File Based On Selections

jagannalla — Thu, 26 May 2011 10:20:26 GMT

Hi,

- I had a table like following code:

Table1:

load * inline[A,B,C,D,E];

- I created a qvd file for table1(Table1.qvd). Now, i want to display all the columns of table1 in the list box for that i written a code like this:

Table2:

load * inline [ Column

E];

- In sheet i taken the listbox with field " Column " and given Presentaion as " LED CheckBoxes".

Now my task is based on selection in the list box i want to load the created qvd file(Table1.qvd).

For eg:

If i selected A,B in the listbox from the Table1.qvd file i should load only A,B columns after clicking the button in the sheet.

Load Fields from Qvd File Based On Selections

Thu, 26 May 2011 11:21:26 GMT

Hi,

Maybe I understand you wrong. But you can't load data from a .qvd vía clicking a button. You must load the .qvd in whole in the script so it become a part of your data model. Then you can make selections based on all data loaded...

/@Ungvall

Load Fields from Qvd File Based On Selections

jagannalla — Thu, 26 May 2011 11:41:13 GMT

sorry..I already loaded qvd file in script. To Reload qvw file i return macro in the button. Based on selections in the list box i want to load qvd file.

" I got the solution for my query "

- But it is not working if i select ' ALL the data ' in the listbox. Otherwise it is working fine I mean when i select A or A,B or A,B,C etc.

Re: Load Fields from Qvd File Based On Selections

deepakk — Thu, 26 May 2011 11:42:21 GMT

hi,

Try out the attach appliction. Below are the steps to achieve it.

Create a Macro to get the selection of Field in variable (comma seprated).

Add the Macro in the Select and Change event of the Field. (Goto Document Properties--> Trigger --> Select the Field --> Add Action on Select and Change )

Add the Vriable in the Field Column.

Find a sample file in attachment.

Deepak

Load Fields from Qvd File Based On Selections

jagannalla — Thu, 26 May 2011 14:25:12 GMT

Hi Deepak,

Your code is working superb. But, In my qvw file i had taken two sheets for each sheet there is a button to reload the qvw file. If i click the button in sheet1 at that time the table with " Column " field will not load into my qvw file and if i click the button in sheet2 then the table with "Column " field will be loaded.

- This is b'coz i had taken a conditon in script to load tables.

- When i'm reloading the Fields in the "Feild event triggers" are updating with new fields. So, whatever Action given for "column" field is missing.

How can i overcome this.

Load Fields from Qvd File Based On Selections

jagannalla — Thu, 26 May 2011 14:39:26 GMT

- But i got solution . if i select only few not all..

- I had created one variable (vtest) and in button with action variable(vtest) , =GetFieldSelections(Column,',')

- In script as same as $(vtest).

Re: Load Fields from Qvd File Based On Selections

deepakk — Mon, 30 May 2011 14:32:51 GMT

cool..... .. best of luck... for future challenges..

Load Fields from Qvd File Based On Selections

jagannalla — Tue, 31 May 2011 05:26:07 GMT

Deepak what is the solution if i select all in the listbox.......thankq

Re: Load Fields from Qvd File Based On Selections

deepakk — Tue, 31 May 2011 08:59:31 GMT

hi,

If you select all fields, all the fields will get stored in the variable.

Check my application.

Deepak

Load Fields from Qvd File Based On Selections

Tue, 31 May 2011 14:29:52 GMT

Hi, jagannalla

Can you share your application please

Vladimir

Re: Load Fields from Qvd File Based On Selections

jagannalla — Wed, 01 Jun 2011 04:55:41 GMT

It is working now.......

I'm attaching my file.

Load Fields from Qvd File Based On Selections

Wed, 01 Jun 2011 11:51:55 GMT

Thank you