Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate field in load editor

Hi, I have problem with create new field in the load data editor

Capture.PNG

Capture.PNG

I would like to have a field to calculate if the KPIs performance exceed the target by more than 10 %, the following is what i try to do, but it fails.

AdditionTable:

Load

  "KPI(s)",

    if(((Sum({$<Types={'Performance'}, Months={'1/12/2015'}>} KPIValue) - Sum({$<Types={Target}, Months={'1/12/2015'}>} KPIValue))/Sum({$<Types={Target}, Months={'1/12/2015'}>} KPIValue))>=0.1, ('Yes'), ('')) as "MoreThan10%"

Resident KPIDetails;

4 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

You can not write set expression in LOAD statement. you have to create multiple tables and perform this operation in load script.

Is there a reason you have to compute this in LOAD script?

Not applicable
Author

Hi Phaneendra Kunche, thanks for reply:)  i would like to count the number of KPI exceed the target by more than 10%, and able to trace those KPIs in detail.

balkumarchandel
Specialist II
Specialist II

If you just want to get the count of KPI's which exceed 10% of target.

you can move your expression in UI side because Set expressions are not allowed in Script side.

or you can remove you set analysis use group by in your load and do your aggrigation (Sum()) including other required conditions.

Thanks

BKC

nizamsha
Specialist II
Specialist II

If(sum({$<Type={"Target"}>} Amount)>(sum({$<Type={"Performance"}>} Amount) and

sum({$<Type={"Target"}>} Amount)>10),

sum({$<Type={"Target"}>} Amount))

Might be u r looking like this