topic Re: Variable declaration in QlikView

Variable declaration

Anonymous — Sun, 01 Nov 2015 09:00:41 GMT

Hello All,

I have one field which contains 100 unique value. I want to list down all fields value under one variable at script level. Below is the example;

swuehl — Sun, 01 Nov 2015 17:51:59 GMT

Maybe like

TMP:

LOAD CONCAT(DISTINCT Category, ', ') as Tmp

RESIDENT YourTableWithCategory;

LET vCat = Peek('Tmp',0,'TMP');

TMP:

LOAD CHR(39) & CONCAT(DISTINCT Category, CHR(39)& ', ' & CHR(39) ) & CHR(39) as Tmp

RESIDENT YourTableWithCategory;

LET vCat = Peek('Tmp',0,'TMP');

then

DROP TABLE TMP;

marcus_sommer — Sun, 01 Nov 2015 17:53:04 GMT

You could use concat for this:

concat:

load concat(distinct Category, chr(39) & ',' & chr(39)) as CategoryList From xyz;

let vCategoyList = peek('CategoryList', 0, 'concat');

and then you could use '$(vCategoryList)' within your functions.

- Marcus