Show column if both dimensions are equal

[jjremy]

Hi everyone,

I'm learning QlikSense and i'm trying to understand how the 'show column if' works. As I understood from the dimension, I should write there some expression and if that expression is true, the column will be in the chart.

But I struggle to use it. I have to following problem:

So basically, I have two dimension in columns, and i would like to only show the columns were they are equals (like for example, the column 2023->2023), and hide the other ones. But if i write an expression like ONGJR=histongjr, nothing happens. 
Thank you for your time and answers 🙂
Have a good day,

[rubenmarin · Accepted solution]

Hi, the hide column expression hides all the dimension, not only some values of the dimension.

For that case you can try with a calculated dimension like Aggr(If(histongjr<>ONGJR,histongjr),ONGJR,histongjr) instead of just 'histongjr', and uncehck the option to show null values

[Aasir]

In the 'Data' panel and locate your chart, select 'Edit.' In the 'Expressions' section, locate the 'Show column if' field.

=ONGJR=histongjr

[jjremy]

Thanks, I slightly modified it, but it worked in the end 🙂