Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ravishinge
Contributor

Converting variables into Field

hello Guys,

Needed help .

I have created a variable

SET COST= A(expression) +B( expression) ;

Now i need to use COST in the script as a field , How do i convert it ?

I need something like this :-

COST as NewCost field so that I can use NewCost for my further calculation. 

Kindly help .

Thanks,

Ravi 

4 Replies

Re: Converting variables into Field

What is A and B here? field names or some kind of calculations with functions such as Sum, Min, Max, Avg?

ravishinge
Contributor

Re: Converting variables into Field

Thanks for reply !

Set Cost= (Count({$<Winstatus={'Lost'}>} distinct  Winproject)

+ Count({$<Winstatus={'Canceled'}>} distinct  Winproject));

Re: Converting variables into Field

What is the script you have so far?

ravishinge
Contributor

Re: Converting variables into Field

[Project1]:

LOAD

  "Id Project"

  ''Region''

here i want to use

Cost as NewCost ,

  

FROM [Project.qvd]

(qvd);

Community Browser