topic Re: Exclude '*' value using exclude(e) in set analysis. in QlikView

Exclude '*' value using exclude(e) in set analysis.

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want the result exclude '*' using e in set analysis

for example. "=Count({$<ADVANCEID=e({1<ADVANCEID={'*'}>})>}ADVANCEID)". But this is not working.

Pleas help me out guys...

sunny_talwar — Mon, 09 May 2016 18:22:11 GMT

Try this:

=Count({$<ADVANCEID = ADVANCEID = {" =ADVANCED <>'*' "}>})>}ADVANCEID)

Also attaching a small sample where I tried to test it out