topic Re: Showing table value using a Where FieldName = variable in QlikView

Showing table value using a Where FieldName = variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello

This is my scenario:

I have an Employees table that has all User related information in it.

Fields: %EmployeeID, Emp.FullName

I have a Sales table that has all sales related information in it, that is joined to the Employees table

Fields: %EmployeeID, Sales.FullName

I have a Finance table that is an island and not connect at all - and it cannot at all be join for any reason.

Fields: Fin.EmployeeID, Fin.FullName, Fin.Salary

Users who open the QlikView app, are authenticated through LDAP, this verifies them using the data in the Employees table.

A variable called vUserName is set to their name at point of opening the app. (for example - variable = John Doe)

Now the problem:

I need to use a text object to display - to the User who is logged in - their Salary.

Because I am not joined to the employees table, or Sales table - I cannot retrieve the correct salary for John Doe.

I wanted to know if i could somehow get it by doing this:

IF( vUserName = Fin.FullName,Fin.Salary,Null() )

I have the vUserName variable - its set to John Doe,

the Finance table has one row per User, so there is a John Doe in the Fin.FullName field.

How can I get this expression to work?

Any help would be greatly appreciated

Many thanks!

vishsaggi — Sat, 28 Oct 2017 01:15:15 GMT

So what is happening when you trying to do this?

IF( vUserName = Fin.FullName,Fin.Salary,Null() )

Anil_Babu_Samineni — Sat, 28 Oct 2017 02:50:57 GMT

How you are defining vUserName in overview of variable?

Anonymous — Sun, 29 Oct 2017 20:02:45 GMT

It doesn't work

I just get a '-' as a response

Anonymous — Sun, 29 Oct 2017 20:03:54 GMT

vUserName is set like this:

=Only({$<SalesPerson>}SalesPerson)

woshua5550 — Mon, 30 Oct 2017 07:24:19 GMT

try this

=Only({<[Fin.FullName]={'$(vUserName)'}>}[Fin.Salary])

Anonymous — Mon, 30 Oct 2017 15:36:12 GMT

Amazing!!
Thank you!