Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get Current selected value at load time

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Please find the attached application.

Hope it helps.

Regards

Amar Nath

View solution in original post

7 Replies
sivarajs
Specialist II
Specialist II

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);

Not applicable
Author

Hi

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

sivarajs
Specialist II
Specialist II

see the attached file

Not applicable
Author

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

sivarajs
Specialist II
Specialist II

see the sample again

Not applicable
Author

Hi,

Please find the attached application.

Hope it helps.

Regards

Amar Nath

Not applicable
Author

Thanks  a lot to both of you

that is Perfact.