Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a customer request to develop a table with different expressions in each line, e.g., for line 1 of the table a set of expressions is used, for line 2, a different set of expressions is used. Is this possible in qlikview? I've tried to load an inline of the dimensions used and a conditional on the expressions but it only works when the dimension is selected, which is not the intended result.
Thanks in advance.
You need to post example data to clarify your request
regards
Marco
Please upload a sample application.
I can't upload a sample because I can't develop what I'm trying to achieve, hope this print clears things...different dimension names = different expressions used in the table.
You could use RowNo() to determine the number of the line and use if statements to determine the expressions to use for example if (RowNo()=1,Expr1,Expr2)
Thank you kamal, it does the trick, my only question is about the performance of the if clause, but anyway it's exactly what I was looking for.
Any other less expensive approach?