Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
paweln
New Contributor II

How to show only specific rows in a table?

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?

tabelka.PNG

 

 

4 Replies
anushree1
Valued Contributor II

Re: How to show only specific rows in a table?

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
New Contributor II

Re: How to show only specific rows in a table?

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

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

here.PNG

anushree1
Valued Contributor II

Re: How to show only specific rows in a table?

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

paweln
New Contributor II

Re: How to show only specific rows in a table?

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?