Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Variable creation

Can I create a variable in order to be used afterwards in other formulas?

if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100) as Variable

So I can use it then as

(Variable/22)*10) +sum([Total Time Spent]))/(sum(timeuser)*10)

instead of

(((if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100)/22)*10)+sum([Total Time Spent]))/(sum(timeuser)*10)

Thanks!

Tags (2)
1 Solution

Accepted Solutions
phaneendra_kunc
Valued Contributor III

Re: Variable creation

Yes. it is possible.

Try adding your variable in Data Load Editor. like below.

SET vExp = if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100);

And then reference this in your expression like below.

(($(vExp)/22)*10) +(sum([Total Time Spent]))/(sum(timeuser)*10)

Find attached for you reference.

2 Replies
phaneendra_kunc
Valued Contributor III

Re: Variable creation

Yes. it is possible.

Try adding your variable in Data Load Editor. like below.

SET vExp = if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100);

And then reference this in your expression like below.

(($(vExp)/22)*10) +(sum([Total Time Spent]))/(sum(timeuser)*10)

Find attached for you reference.

phaneendra_kunc
Valued Contributor III

Re: Variable creation

Jose,

Can you mark this thread "Correct Answer"  if above solution solves your problem. That way other people can find this useful.

Community Browser