topic How to implement formulas in load script in QlikView

How to implement formulas in load script

Wed, 06 May 2015 12:39:45 GMT

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?

Re: How to implement formulas in load script

beck_bakytbek — Wed, 06 May 2015 12:44:25 GMT

Hi John,

try to Resident Load, here you can combine all expressions

Beck

Re: How to implement formulas in load script

maxgro — Wed, 06 May 2015 12:47:05 GMT

remove sum

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

Re: How to implement formulas in load script

Wed, 06 May 2015 12:51:00 GMT

cool, this works 🙂

I guess this was one of the VERY easy questions!

Re: How to implement formulas in load script

Wed, 06 May 2015 12:51:46 GMT

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

I'm a very beginner in QV!

Re: How to implement formulas in load script

beck_bakytbek — Wed, 06 May 2015 12:56:22 GMT

No problem, Please show this

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

kindly

Beck

Re: How to implement formulas in load script

Thu, 07 May 2015 07:42:13 GMT

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?

Re: How to implement formulas in load script

beck_bakytbek — Thu, 07 May 2015 08:35:10 GMT

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

Re: How to implement formulas in load script

Thu, 07 May 2015 13:21:30 GMT

I attached some example data.