Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER NOW
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