topic Re: if or set analyses in QlikView

if or set analyses

tanjavarwijk — Wed, 15 Jan 2014 08:41:46 GMT

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)

jvishnuram — Wed, 15 Jan 2014 08:48:24 GMT

Hi Tanja,

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

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

Use this.

jagan — Wed, 15 Jan 2014 09:09:48 GMT

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.