ValueList and $Field Friendship problem (need to make correl matrix)

ikarimov — Sat, 16 Nov 2024 18:56:38 GMT

Hello!

I need help to build correct dynamic measure, maybe some idea? how make it work and calculate correct numbers.

data: https://gist.github.com/pranaydave/8b9453d354d67afae834e3d12be8c5fe#file-cars_data-csv

model in body )

Re: ValueList and $Field Friendship problem (need to make correl matrix)

ikarimov — Mon, 16 Mar 2020 17:09:26 GMT

hi again i decided it myself

measure = $(=Variable1) = =concat(
'if($Field='&
chr(39)
&$Field&
chr(39)
&',correl(['
&$Field&
'],['
&valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))
&']))*if(valuelist('
&Variable2
&')='
&chr(39)&valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))&chr(39)
&',1,null())','&')

Variable2 =concat(chr(39)&$Field&chr(39),',')

dimension1 = $Field1

dimension2 =valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))

topic Re: ValueList and $Field Friendship problem (need to make correl matrix) in QlikView

ValueList and $Field Friendship problem (need to make correl matrix)

Re: ValueList and $Field Friendship problem (need to make correl matrix)