Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how i can use existing expresions to create new expresions?

how i can use existing expressions to create new expression? for a simple example i have two expressions(A,B) which i need to get the third one by multiplying those two. (A*B).

3 Replies
Sokkorn
Master
Master

Hi,

For example

Expression 1:

    1. Label = Exp1

    2. Definition = 2    (use your calculation)

Expression 2:

    1. Label = Exp2

    2. Definition = 3    (use your calculation)

Expression 3:

    1. Label = Exp3

    2. Definition = [Exp1]*[Exp2]

This mean that, for expression you can take label from expression 1 & 2 for any calculation

Untitled.png

Regards,

Sokkorn

Not applicable
Author

In a  chart you can use the column number to represent the expression for example if you want to use an expression that is present in column 2 you can write as follows

if(column2= null,' ', ' ')

Not applicable
Author

7-10-2014 11-39-14 AM.png

This will work as long as subsequent expressions are not promoted in place of column 1 and/or column 2