topic Re: Dynamic Variable selection in QlikView

Dynamic Variable selection

Anonymous — Sat, 29 Jul 2017 19:32:32 GMT

Dear Experts,

I am having some trouble to create a dynamic variable in Qlik.

I am doing as below.

Below is the data.

key, code

1,x

2.y

3,z

Variable : vkey=Max(Key)

which will set 3 as a value.

now how can i set the variable 2 as a default?

however it will still can change dynamically and can not be hard coded.

your response will be highly appreciated!

stalwar1‌ Please need you help!

Re: Dynamic Variable selection

tresB — Mon, 31 Jul 2017 09:04:06 GMT

Could you explain your business case in a bit more detail? May be with a sample qvw?

Re: Dynamic Variable selection

rahulpawarb — Mon, 31 Jul 2017 09:29:16 GMT

May be this:

Data:
LOAD * INLINE [
key, code
1,x
2.y
3,z
];


//Fetch the maximum key value
tmpData:
LOAD Max(key) AS maxkey
Resident Data;


LET vkey = Peek('maxkey', 0, 'tmpData');


DROP Table tmpData;

Regards!

Rahul Pawar

Re: Dynamic Variable selection

effinty2112 — Mon, 31 Jul 2017 09:39:50 GMT

Hi Amalesh,

Do you want vkey to be no lower than 2?

vkey = rangemax(2, max(Key))

Re: Dynamic Variable selection

Kushal_Chawda — Mon, 31 Jul 2017 10:16:02 GMT

try this

Max({1}Key)

Max(total Key)

Re: Dynamic Variable selection

Anonymous — Wed, 02 Aug 2017 06:35:44 GMT

Hi Andrew,

Let me test it then I will let you know.

And, thank you guys for your prompt reply.

Regards,

Amalesh

Re: Dynamic Variable selection

Anonymous — Sat, 05 Aug 2017 05:22:28 GMT

Hi Andrew,

The vkey value could be less than 2.

I have used a horizontal list box and there are different value available, in the list box 2 will be defult value while I click other options the value will change accordingly.

I can set max value as a defult.

Thanks

Amalesh