topic Re: Associative Array Data Structure in Qlikview in QlikView

Associative Array Data Structure in Qlikview

Wed, 25 Nov 2020 16:16:04 GMT

Does Qlikview have Associative data Structure. where I can define a variable with key-value pair ?

swuehl — Thu, 05 May 2016 18:51:06 GMT

There are no real data types in QlikView, no basic / generic and no kind of abstract types.

What do you want to achieve with the associative array?

Maybe you can work around creating a (island) table with one field being the key and one the value.

Then you could get the value from key e.g. by using

=Only({<KeyField = {'KeyValue'}>} ValueField)

ziadm — Fri, 06 May 2016 04:48:23 GMT

There are no Data type such as Structure but you can create you own variable names using the dot conventions for ease of use.

Let MyStruct.Value= 1;

Let MyStruct.Name= 'XYZ''

You may also make this as an array

Let MyStruct.Value1= 1;

Let MyStruct.Name1= 'XYZ''

Let MyStruct.Value2= 2;

Let MyStruct.Name2= 'WXY''

you array index can be incremented by using and index variable in a for loop