Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Partner
Partner

Custom table

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.

5 Replies

Re: Custom table

You need to post example data to clarify your request

regards

Marco

senpradip007
Valued Contributor III

Re: Custom table

Please upload a sample application.

Partner
Partner

Re: Custom table

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.

example.JPG.jpg

Highlighted
sadikkamal
New Contributor III

Re: Custom 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)

Partner
Partner

Re: Custom table

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?