topic Re: Select Only Value(String1) = Value(String2) in QlikView

Select Only Value(String1) = Value(String2)

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

Hi everybody,

I have a table box with many informations from different tables.

To simplify 🙂 :

my table1 contains the fields SERVER and ACCOUNT

my table2 contains the fields SERVER and LOGIN

When i make my table box, i have the next table

But i only want when Value(ACCOUNT) = Value(LOGIN) as below

Thanks for yours answers !

sunny_talwar — Thu, 17 Oct 2019 15:28:56 GMT

You can create this in a straight table may be

Dimensions
SERVER
LOGIN

Expression

If(ACCOUNT = LOGIN, ACCOUNT)

rubenmarin — Thu, 17 Oct 2019 15:30:28 GMT

Hi, you can't set expression in a table box, try with a simple table chart. Server and account as dimension and one expression:

If(LOGIN=ACCOUNT, LOGIN)

sunny_talwar — Thu, 17 Oct 2019 15:45:55 GMT

Hi Ruben

I think because an Account seem to have multiple LOGIN, this won't work with just Account and Server as dimension... Server and Login works though

rubenmarin — Thu, 17 Oct 2019 15:49:52 GMT

Hi Sunny, it has been a while since last chat.

You are right, as usual. 🙂

Fanch — Thu, 17 Oct 2019 15:55:56 GMT

Hi,

you are too strong !! 💪

Greats, Thanks