Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
andrefpc
Partner - Creator II
Partner - Creator II

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
MarcoWedel

You need to post example data to clarify your request

regards

Marco

senpradip007
Specialist III
Specialist III

Please upload a sample application.

andrefpc
Partner - Creator II
Partner - Creator II
Author

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

Anonymous
Not applicable

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)

andrefpc
Partner - Creator II
Partner - Creator II
Author

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?