topic Re: Set analysis with <> in QlikView

Set analysis with <>

Anonymous — Wed, 19 Nov 2014 16:02:51 GMT

Hi,

i am having issues with a <> in a set analysis? How can i solve this?

=-count( {<PF_OUT_Gruppo_Destinazione <> {'Cancellazione Albo'} ,PF_OUT_Gruppo_Origine = {'$(vAlbo1)'} >}DISTINCT PF_OUT_Origine_Promotore)

Re: Set analysis with <>

jpenuliar — Wed, 19 Nov 2014 16:07:21 GMT

try "-=" instead of "<>"

you might get a red line on the expression window but if Expression OK, it works

Re: Set analysis with <>

Anonymous — Wed, 19 Nov 2014 16:15:28 GMT

doesnt work 😞

Re: Set analysis with <>

Wed, 19 Nov 2014 16:19:30 GMT

Hi,

Try siomething like this:

count( {<PF_OUT_Gruppo_Destinazione = PF_OUT_Gruppo_Destinazione - {'Cancellazione Albo'} ,PF_OUT_Gruppo_Origine = {'$(vAlbo1)'} >}DISTINCT PF_OUT_Origine_Promotore)

Regards.

Re: Set analysis with <>

jpenuliar — Wed, 19 Nov 2014 16:25:48 GMT

hmm, how about PF_OUT_Gruppo_Destinazione = {'*'} - {'Cancellazione Albo'}

Re: Set analysis with <>

Wed, 19 Nov 2014 16:28:09 GMT

Try:

count( {<PF_OUT _Gruppo_Destinazione -= {'Cancellazione Albo'}, PF_OUT_Gruppo_Origine = {'$(vAlbo1)'} >}DISTINCT PF_OUT_Origini_Promotore)

if that does not work there may be an issue with your variable and how you have that formatted.

Re: Set analysis with <>

simondachstr — Wed, 19 Nov 2014 16:31:24 GMT

Niccolo, using -= does work - the expression editor weirdly underlines it as red but the expression itself evaluates correctly.

Re: Set analysis with <>

qlikconsultant — Wed, 19 Nov 2014 16:31:26 GMT

Yes QlikView is case sensitive.