Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
Sorry, as I wrote, I'm a noob.
Where should I place that expression? Here? For each column?
Place it in the expression editor , the very first f(x) box that you see for each measure you have created
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?