Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted

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
Highlighted

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)

Highlighted

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)

Highlighted

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

Highlighted

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