How to show only specific rows in a table?

[paweln]

Dear all,

I've just started discovering Qlik and I love it already!

I have simple table. I want to see in it only rows that have "1" in second column. I know I can use filtering but I don't want that column to be visible in the table. Should I use some formula?

[anushree1]

Yes in each expression that you have used you must add the condition

{<Dimension2={1}>} for eg : if your expression is like sum(Measure1) modify it as sum({<Dimension2={1}>}Measure1)

[paweln]

Sorry, as I wrote, I'm a noob. 

Where should I place that expression? Here? For each column?

[anushree1]

Place it in the expression editor , the very first f(x) box that you see for each measure you have created

[paweln]

OK, I had no idea about set expressions. I read about it and as I understand I can use them only with aggregation functions. What If my table consists of dimensions only?