Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

what's wrong

Hi Community,

could you help me?

error in expression


IF((Commessa = {'ASSTEL'}), 1,sum({<Commessa = {'ASSTEL'}>} [TotOreLavorate]))

I can not understand what's wrong

4 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Try this

If(Comessa = 'ASSTEL',1,Sum( {<Commessa = {'ASSTEL'}>}[TotOreLavorate]))

sunny_talwar

May be this?

If(Commessa = 'ASSTEL', 1, Sum(TOTAL {<Commessa = {'ASSTEL'}>} [TotOreLavorate]))

hic
Former Employee
Former Employee

The small error is that you have a bracket too much (after 'ASSTEL') and the big problem is that Commessa is a naked field reference. See Use Aggregation Functions!

HIC

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

I may have misplaced the question.


Immagine.png


I'm not able to create a function


Column C

if (Commessa = 'ASSTEL' and (CTRAAN = 'C'), SUM(HOUR), 1)



Column N

if (Commessa = 'ASSTEL' and (CTRAAN = 'N'), SUM(HOUR), 1)