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: 
upaliwije
Creator II
Creator II

Error in expression

Hi friends

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE<>{"00000"}>} [PREMIUM] )

The expression is not working. Pls help me to correct it

Thanks

1 Solution

Accepted Solutions
sushil353
Master II
Master II

Hi,

Try below expression:

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE-= {"00000"}>} [PREMIUM] )

HTH

sushil

View solution in original post

5 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Try:

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE={{*}-{"00000"}>} [PREMIUM])



sushil353
Master II
Master II

Hi,

Try below expression:

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE-= {"00000"}>} [PREMIUM] )

HTH

sushil

Marcellino_Groothof
Contributor III
Contributor III

Hi,

Try this,

 

sum( {$<YEAR = {$(=Only([YEAR]))},CC_CODE-={"00000"}>}  [PREMIUM] )

Regards,

Marcellino

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE-={"00000"}>} [PREMIUM])


Regards

ASHFAQ

upaliwije
Creator II
Creator II
Author

Thanks all