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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Associative Array Data Structure in Qlikview

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

2 Replies
swuehl
MVP
MVP

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

Data Types in QlikView

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
Specialist
Specialist

Hi

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