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

if or set analyses


Why do I become different answers, the If is right but I want to use the other

(if(Invoiced<>0 and Year=($(=Year(Today()))),Value_SalesAmount))



//Sum({<Invoiced={'<>0'},Year={$(=Year(Today()))}>}Value_SalesAmount)

2 Replies
jvishnuram
Partner - Creator III
Partner - Creator III

Hi Tanja,

The syntax for '<>' not equal condition in set analysis is

sum({$<Invoiced-={"0"},Year={"$(=Year(Today()))"}>}Value_SalesAmount)

Use this.

VJ
jagan
Partner - Champion III
Partner - Champion III

Hi,

Check this expression, you need to use -= to exclude the values instead of <>

Sum({<Invoiced-={'0'},Year={$(=Year(Today()))}>}Value_SalesAmount)


Hope it helps you.


Regards,

Jagan.