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: 
mitjap
Contributor III
Contributor III

Sum in tables

I came to the problem that i hard for me to overcome.

i added screen shot as data files are big

in right table everything is correct as i use to calculate "kos" this expression:

if(Count([Ime delavca])=2,(sum(if(Delavci=2,((kol)/2)))) + (sum(if(Delavci=1,((kol))))), (sum(if(Delavci=2,((kol))))) + (sum(if(Delavci=1,((kol))))))

it uses other fields so i can filter out thing

it works great as i use in table "dat.autocalendar.date" and "kataloška".

the problems is on left table as i dont have "dat.autocalendar.date" and "kataloška" in table. my count and same expresion wont work in left table.

is there possibility that i write expression in left table on the way that is calculate the same as in right table?

 

 

 

 

 

0 Replies