How to implement formulas in load script

[#1]

Hi all

In the attached screenshot I have an if-statment to create a new dimension called [Running Time in h] by selecting only data from Running Time in combination with [Record Type] A.

But this do not work.

Any idea why?

[beck_bakytbek]

Hi John,

try to Resident Load, here you can combine all expressions

Beck

[maxgro · Accepted solution]

remove sum

if([field]='A', [field2]/3600) as Field3

[#4]

cool, this works 🙂

I guess this was one of the VERY easy questions!

[#5]

I have to learn first what exactly a resident load means.

I'm a very beginner in QV!

[beck_bakytbek]

No problem, Please show this

https://community.qlik.com/message/604641#604641

kindly

Beck

[#7]

Hi Beck,

maybe now I have a topic regarding resident load.

I try to implement "OPERATING TIME" as new dimension (formula ,marked yellow). But it do not work. As result I get "FIELD NOT FOUND <Technical Downtime in h>.

Maybe here it is useful to implement resident load?

[beck_bakytbek]

Hi John, in the case of resident load, you need two dimension, and in conjuction with those dimension you can create one additional dimension.

do you have any values, if you show, we can find a appropriate solution for your issue

kindly

Beck

[#9]

I attached some example data.