Discussion board where members can get started with QlikView.
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 !
Go to Solution.
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
View solution in original post
You can create this in a straight table may be
If(ACCOUNT = LOGIN, ACCOUNT)
Hi, you can't set expression in a table box, try with a simple table chart. Server and account as dimension and one expression:
Hi Sunny, it has been a while since last chat.
You are right, as usual. 🙂
you are too strong !! 💪