Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Conditional Table Column

I have three columns that I need to compare. I want to show the entire row IF the first column does NOT match the second OR third column.

I tried a 'show column if' with a function "=[SN Prefix]<>[HN Prefix] or [SN Prefix]<>[User Prefix]", but it still returned values where all three match. (i.e. If all three match, don't show the row).

How do I get this to run in the table without adding exceptions the data load?

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Conditional Table Column

this formula must be used in Field Field

 

in place of "SN Prefix"

should use

=if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],[SN Prefix])

View solution in original post

4 Replies
Highlighted
Contributor III
Contributor III

Re: Conditional Table Column

Hello,

I think what you are looking for would be the

 

to Dimension (Hiding Nulls)

=if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],[SN Prefix])

 

For Measurements something like

=Sum(if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],Value))

 

Capturar.PNG

I used as an example in the table below

LOAD * Inline [
SN Prefix,HN Prefix,User Prefix,Value
A,A,A,1
B,B,B,2
B,C,B,3
D,C,B,4
E,B,D,5
F,F,F,6
]
;

 

Regards

Rafael Yoshida

Contributor III
Contributor III

Re: Conditional Table Column

I tried that formula, and it still shows all. If all three values match, I need the row to be hidden. In the image, the first row should be hidden as they all match

Highlighted
Contributor III
Contributor III

Re: Conditional Table Column

Also, in the variable I only have these areas to put formulas (image below). 

Capture2.PNG

 

Highlighted
Contributor III
Contributor III

Re: Conditional Table Column

this formula must be used in Field Field

 

in place of "SN Prefix"

should use

=if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],[SN Prefix])

View solution in original post