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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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