topic Re: Get Current selected value at load time in QlikView

Get Current selected value at load time

Mon, 04 Jun 2012 08:35:50 GMT

Hi All,

I want to get current selected value at loading time.

I mean i have few tables .In data i metained one field TableName that field contained all table names

What i want that if I select few table name from that field that will store in another field .

Only select value will store in anothe filed.

And i want to do this on script level.

Thanks in advance

Regards

Chanchal

Re: Get Current selected value at load time

sivarajs — Mon, 04 Jun 2012 11:17:05 GMT

Create a variable using ctrl+alt+v eg.,myvar

define variable like

myvar=getfieldselection(fieldname)

In edit script

use the following

tab1:

load '$(myvar)' as filed1 autogenerate(1);

store tab1 into tab1.qvd(qvd);

tab2:

load * from tab1.qvd

concatenate(tab2) //stores whenever you are selecting and loading

load '$(myvar)' as filed1 autogenerate(1);

store tab2 into tab1.qvd(qvd);

Get Current selected value at load time

Mon, 04 Jun 2012 11:44:41 GMT

thanks for quik response

but this logic is not working.

even variable is not showing the values after executing script at table view

showing function only

Thanks in advance for any help

Regards

Chanchal

Re: Get Current selected value at load time

sivarajs — Mon, 04 Jun 2012 12:42:12 GMT

see the attached file

Get Current selected value at load time

Tue, 05 Jun 2012 05:52:04 GMT

Hi Sivraj

Thanks a lot.

that is what i want.

But there is one problem that if i select more than one values that will come in single row along with

, symbol.

Is there any solution that i can show these values in list .I mean that if i select 3 rows then that will come in 3 rows .

Why i want this because these values i want to use in loop for creating qvd.

Thanks in advace

Regards

Chanchal

Re: Get Current selected value at load time

sivarajs — Tue, 05 Jun 2012 06:36:10 GMT

see the sample again

Re: Get Current selected value at load time

Tue, 05 Jun 2012 07:09:47 GMT

Hi,

Please find the attached application.

Hope it helps.

Regards

Amar Nath

Re: Get Current selected value at load time

Tue, 05 Jun 2012 14:34:51 GMT

Thanks a lot to both of you

that is Perfact.