# 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)

(((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
Valued Contributor III

## Re: Variable creation

Yes. it is possible.

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
Valued Contributor III

## Re: Variable creation

Yes. it is possible.

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.

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.