topic Re: Using * in Expression in QlikView

Using * in Expression

qlikviewwizard — Wed, 08 Apr 2015 02:58:10 GMT

What is the ENAME = {'*'} in the below expression?

sum(

{<ENAME = {'*'},[PROMOTION_DATE] = {">=$(=yearstart(Date(HIREDATE),0,4)) <=$(=Date(HIREDATE))"},

[JOB] = ,COUNTRY = P({$<COUNTRY_CODE = {'US','UK'}>}),

>} [SALARY]

)

Thanks in advance.

ramoncova06 — Wed, 08 Apr 2015 03:03:02 GMT

that gives you all the values for that field, in some cases is can include nulls

danieloberbilli — Wed, 08 Apr 2015 03:08:21 GMT

I think it should have the same effect like {<ENAME=, ...>} this would ensure that there is no limitation due to a selection in the field ENAME

qlikviewwizard — Wed, 08 Apr 2015 03:32:57 GMT

Thank you All.