Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

Select Only Value(String1) = Value(String2)

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 

Login1.PNG

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

Login2.PNG

Thanks for yours answers !

1 Solution

Accepted Solutions

Re: Select Only Value(String1) = Value(String2)

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

image.png

View solution in original post

5 Replies

Re: Select Only Value(String1) = Value(String2)

You can create this in a straight table may be

Dimensions
SERVER
LOGIN

Expression

If(ACCOUNT = LOGIN, ACCOUNT)

Re: Select Only Value(String1) = Value(String2)

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)

Re: Select Only Value(String1) = Value(String2)

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

image.png

View solution in original post

Re: Select Only Value(String1) = Value(String2)

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

You are right, as usual. 🙂

Partner
Partner

Re: Select Only Value(String1) = Value(String2)

Hi,

you are too strong !! 💪

Greats, Thanks