topic Re: Number comparison in QlikView

Number comparison

marco_puccetti — Fri, 19 Jun 2015 10:25:14 GMT

Hello, i need to know how to make a comparison between two numbers.

I've tried with -= to check de difference between two number but it doesn't work, any idea?

Thanks

Marco

Re: Number comparison

sunny_talwar — Fri, 19 Jun 2015 10:26:26 GMT

Can you share the data in the two number fields that you are trying to compare?

Re: Number comparison

sunny_talwar — Fri, 19 Jun 2015 10:27:01 GMT

and possible the format and decimals for both the fields

Re: Number comparison

marco_puccetti — Fri, 19 Jun 2015 10:44:29 GMT

It is simply the comparison between a formula and the 0 value:

If(

Count({<STATO={'ATTIVATA'},RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-12))<=$(=max(RICHIESTA_APERTURA)-6)"}> }DISTINCT NUMERO_PROPOSTA)

Count({<STATO={'ATTIVATA'},RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-6))<=$(=max(RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

)

<>0

Thanks

Marco

Re: Number comparison

alexandros17 — Fri, 19 Jun 2015 10:46:57 GMT

Nothing strange but ... could you share the doc.?

Re: Number comparison

sunny_talwar — Fri, 19 Jun 2015 10:47:02 GMT

I don't see why this comparison wouldn't work, unless I am missing something small here. May be someone else can spot what might not be working for you.

Best,

Sunny

Re: Number comparison

marco_puccetti — Fri, 19 Jun 2015 10:58:24 GMT

Can you tell me the operator to use?

Thanks

Marco

Re: Number comparison

alexandros17 — Fri, 19 Jun 2015 11:10:41 GMT

Your logic is correct ...