topic Re: how to compare variable value to Field multiple values in QlikView

how to compare variable value to Field multiple values

Wed, 16 Mar 2016 19:58:25 GMT

Hi all,

i am facing some issue recording Compare the variable values to field values

like i have one variable like -----Vemp='ram'

now i have one table like empid empname deptid salary

1 ram 10 5000

2 kiran 11 15000

3 ravi 10 25000

4 kumar 12 35000

now i need to compare variable value to empname field values

like if(empname='$(Vemp)',Deptid,'No Data')

but here i am not able to compare the all fields values to variable values

Could you please suggest the best way

Thanks,

Brahma

Re: how to compare variable value to Field multiple values

swuehl — Wed, 16 Mar 2016 21:12:31 GMT

Try

=Alt( Only({<empname={'$(Vemp)'}>} deptid), 'no data')

Re: how to compare variable value to Field multiple values

Thu, 17 Mar 2016 05:42:31 GMT

Thanks swuehl ,

it"s working for deptid but

let as assume in table now added a new feild like "referencename"

feilds ---- empid empname deptid salary referencename

1 ram 10 5000 bobby

2 kiran 11 15000 hari

3 ravi 10 25000 kasi

4 kumar 12 35000 veeru

=Alt( Only({<empname={'$(Vemp)'}>} deptid), 'no data')--it is working good for Deptid

but when i was trying to get related "referencename" feild value it showing 'nodata'

=Alt( Only({<empname={'$(Vemp)'}>} referencename), 'no data')

Could you please suggest the best way

Thanks,

Brahma

Re: how to compare variable value to Field multiple values

Thu, 17 Mar 2016 06:04:15 GMT

Hi Brahmaiah,

Please use the below expression

SET Vemp='ram'; // declare at edit script

=if(empname=Vemp,deptid,'NoData') // i used this exp at straight table in dimension tab

(or)

=if(empname='$(Vemp)',deptid,'NoData')

i hope this will help you...

Sub2u444‌

Re: how to compare variable value to Field multiple values

Thu, 17 Mar 2016 06:13:55 GMT

Thanks SubbaReddy ,

it will work but

I need to create all the things in variable level.even "=if(empname=Vemp,deptid,'NoData')"--this function also i need to in create variable level

Thanks,

Brahma

Re: how to compare variable value to Field multiple values

Anonymous — Thu, 17 Mar 2016 06:27:14 GMT

Declare variable vName and assign vName='Ram'

in the straight Chart->Calculated dim (=if(Name=vName,ID)

Expression-->Only(ID) Only(Sal)

Hop this will help you.....