Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Avoid [ExpressionColumnName1]+[ExpressionColumnName2] Syntax

Hello guys,

I've got a pivot table with several expressions. Each expression is saved in a variable so I can use $(vExpressionVariable1) syntax in the pivot table to get the result.

I've also got two expressions that are currently dependent on each other as I'm using syntax something like:

1. ExpressionName1:

     [ExpressionName2] + $(vExpressionVariable1)

and

2. ExpressionName2:

     [ExpressionName1] + $(vExpressionVariable1)

There is no problem to use them together in one pivot table. The result is as expected. But my goal is to use them independently in the QV app. Let's say if I just want to display only [ExpressionName1] in the table. Please check the QVW I've attached for better view.

Any ideas will be much appreciated.

Thank you in advance,

~Sergejs

5 Replies
Highlighted
Partner
Partner

Create the 3rd and 4th variables with the contents of ExpressionName1 & ExpressionName2. You just cannot use a column name outside the specified chart itself.

BR

Serhan

Highlighted
Creator
Creator

Hi Serhan,

Yes this is what I tried already. But there is a specific case which doesn't allow me to do that. See the file (qvw) attached. The problem is that one expression is being calculated based on the second expressions result and vise versa. That's the reason why I've currently got them in one pivot table.

Highlighted
Partner
Partner

Hi Sergejs,

Yes, I see you have a problem with before() function.

You need a different perspective then. Deal with these tricks on script side. You need to alter the table and create your columns or flags there.

Hints are : order by, peek().

Just search these tricks above. You may come across in community as well.

BR

Serhan

Highlighted
Creator
Creator

Does anyone else have any other ideas of possible solutions?

Highlighted
MVP & Luminary
MVP & Luminary

You could try to simulate this table-calculation with a (quite) complex aggr() function - http://community.qlik.com/search.jspa?q=aggr+hic&type=post - but I think the suggestions from http://community.qlik.com/people/zekazak with a scripting approach is better.

- Marcus