topic Re: Create a new table through selection in QlikView

Create a new table through selection

Sat, 01 Dec 2012 19:06:28 GMT

Hi,

I would like to create one new table through my selection, its possible?

For example, i have one selection per year, i´d like clicking in button and create a table only with registers of my selection.

Table1:

cod, year

1, 2012

2, 2012

3, 2013

4, 2014

5, 2015

Selection:

2012

Click on button and create a new table...

NewTable:

cod,year

1,2012

2,2012

Thanks,

Robson Henrique

Re: Create a new table through selection

Sat, 01 Dec 2012 19:17:37 GMT

save 2012 (selection) to variable

add partial reload as a trigger on button

in the script use variable to load only 2012 to new table

Re: Create a new table through selection

Sun, 02 Dec 2012 18:50:34 GMT

in my case i have many selections, how do it?

Thanks...

Re: Create a new table through selection

Gysbert_Wassenaar — Sun, 02 Dec 2012 19:36:34 GMT

Here's an example. If you have more selections, just add variables for each field and expand the where clause with the other selections: ...where match(Field1, $(var1)) and match(Field2, $(var2)) and ... etc.