Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

You can create this in a straight table may be

Dimensions
SERVER
LOGIN

Expression

If(ACCOUNT = LOGIN, ACCOUNT)

Highlighted

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

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

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

You are right, as usual. 🙂

Highlighted
Partner
Partner

Hi,

you are too strong !! 💪

Greats, Thanks