Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Milaf
Contributor III
Contributor III

Division gives wrong results in load editor

Hello, I would like to ask for your support for an operation that I can calculate in the frontend but not in the load editor.

Step1:
...

Sum(Acil_Hesap2) as Acil_Hesap2,
Sum(Normal_Hesap2) as Normal_Hesap2 ,
Sum(Toplam_Hesap2) as Toplam_Hesap2,
sum(Acil_Adet2) as Acil_Adet,
sum(Normal_Adet2) as Normal_Adet,
sum(Toplam_Adet2) as Toplam_Adet

...

Step2: (division returns an incorrect result in this step)

...

sum(Acil_Hesap2)+ sum(Acil_Adet) as AcilOran,
sum(Normal_Hesap2)+ sum(Normal_Adet) as NormalOran,
sum(Toplam_Hesap2)+sum(Toplam_Adet)as ToplamOran

...

In fact, the process I want to go to is working on the master item on the front side, but I cannot call the master item to calculate the variable. So I tried to calculate it in the load editor, but it does not work like on the front side.


The calculation I wanted in the final:
(SUM(AcilOran) + sum(NormalOran) +sum(ToplamOran))/3 as TotalDegisim

I hope someone can help me with what I can't see.

Thank you.

 

Labels (1)
2 Replies
Lisa_P
Employee
Employee

Aggregations (like sum) can only be used in the load script in conjunction with the Group by function to aggregate values by a dimension or multiple dimensions.

Parthiban
Creator
Creator

Try to take resident of step 1
like

Table1:

load
Sum(Acil_Hesap2) as Acil_Hesap2,
Sum(Normal_Hesap2) as Normal_Hesap2 ,
Sum(Toplam_Hesap2) as Toplam_Hesap2,
sum(Acil_Adet2) as Acil_Adet,
sum(Normal_Adet2) as Normal_Adet,
sum(Toplam_Adet2) as Toplam_Adet
from path...

Table2:

load

((Acil_Hesap2+Acil_Adet2)+(Normal_Hesap2+Normal_Adet)
+(Toplam_Hesap2+Toplam_Adet))/3 as Final_Result

resident Table1;

 

Just try this suppose this will not work we will try any other method..