Discussion board where members can get started with Qlik Sense.
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?
this formula must be used in Field Field
in place of "SN Prefix"
=if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],[SN Prefix])
View solution in original post
I think what you are looking for would be the
to Dimension (Hiding Nulls)
For Measurements something like
=Sum(if([SN Prefix]<>[HN Prefix] OR [SN Prefix]<>[User Prefix],Value))
I used as an example in the table below
LOAD * Inline [SN Prefix,HN Prefix,User Prefix,ValueA,A,A,1B,B,B,2B,C,B,3D,C,B,4E,B,D,5F,F,F,6];
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
Also, in the variable I only have these areas to put formulas (image below).