topic Re: assigning value from table to a variable in QlikView

assigning value from table to a variable

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

I have a table where the information is sorted in a particular order. Is there a way I can assign a cell value in a particular position (eg, row 1 column 2) to a variable easily? thanks

Re: assigning value from table to a variable

luismadriz — Mon, 20 Nov 2017 01:12:52 GMT

Hi,

Maybe a double For loop and the Peek function?

Re: assigning value from table to a variable

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:19:00 GMT

Title Looks like this?

LET Variable = Peek('TableName', FieldName, 3);

Re: assigning value from table to a variable

ronaldwang — Mon, 20 Nov 2017 03:27:31 GMT

Thanks, I can do this in load script.

I should have made more clear that I want to assign table value to a variable where the table is in the front end. e,g a table where I have calculated the 50 percentile. if I can not achieve this then I will have to go back to insert this information into the original table.

Re: assigning value from table to a variable

Anil_Babu_Samineni — Mon, 20 Nov 2017 03:34:18 GMT

Can you come up with some sample data and result you want to store in variable, Please?

Re: assigning value from table to a variable

woshua5550 — Mon, 20 Nov 2017 03:59:16 GMT

maybe a simple macro can help you , plz check my test file attached

Re: assigning value from table to a variable

ronaldwang — Mon, 20 Nov 2017 04:01:14 GMT

the result table is as below and can be dilemma as user can change the date but the order will be the same, e,g sorting last column from high to low, and I want to assign variable for the 50 percentile of that column to a variable.

Thanks

Re: assigning value from table to a variable

ronaldwang — Mon, 20 Nov 2017 04:09:53 GMT

Thanks, that is a good way of doing it. just curious apart from using marco, any other way to achieve the result.

Re: assigning value from table to a variable

woshua5550 — Mon, 20 Nov 2017 05:04:43 GMT

Concat () + Subfield() also works but there will be a lot of limitations

check "Method 2" in attachment