Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paweln
Contributor III
Contributor III

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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

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

here.PNG

anushree1
Specialist II
Specialist II

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

paweln
Contributor III
Contributor III
Author

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?