topic Re: Custom table in QlikView

Custom table

andrefpc — Mon, 17 Mar 2014 10:43:13 GMT

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.

Re: Custom table

MarcoWedel — Mon, 17 Mar 2014 11:15:17 GMT

You need to post example data to clarify your request

regards

Marco

Re: Custom table

senpradip007 — Mon, 17 Mar 2014 11:18:19 GMT

Please upload a sample application.

Re: Custom table

andrefpc — Mon, 17 Mar 2014 11:36:10 GMT

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.

Re: Custom table

Anonymous — Mon, 17 Mar 2014 12:03:24 GMT

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)

Re: Custom table

andrefpc — Mon, 17 Mar 2014 12:40:40 GMT

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?