topic Re: value match function in QlikView

value match function

santhosh_k_n — Wed, 23 Apr 2014 06:00:35 GMT

Hi all,

I am having 2 columns and am making selection in one of the column.

I need the function to get the matched values in the second column based on first column selection.

Please guide

MK_QSL — Wed, 23 Apr 2014 06:01:39 GMT

Please provide some sample or apps

santhosh_k_n — Wed, 23 Apr 2014 06:07:59 GMT

Consider Below table:

In above table, if i select report name i need to assign the matching report type to a variable.

say, I had selected report name = report3, then i need to assign report type - Type1 to a variable V_temp

Hope you understand

tresB — Wed, 23 Apr 2014 06:10:13 GMT

Define your variable like:

V_temp= [Report type]

MK_QSL — Wed, 23 Apr 2014 06:14:34 GMT

Create a variable

vVar

=Only({<[report name] = {'$(=GetFieldSelections([report name]))'}>}[Report type])

Now use vVar in Text Box and Try to Select report name

its_anandrjs — Wed, 23 Apr 2014 06:21:58 GMT

Update now check

Write a variable like

V_temp =if(Match(GetFieldSelections([report name]),'report1','report2','report3'),'Type1',

if(Match(GetFieldSelections([report name]),'report4','report5','report6','report7'),'Type2'))

SunilChauhan — Wed, 23 Apr 2014 06:39:43 GMT

I am agree with tresesco .

see the attached file