topic Re: Currency Comaprision in QlikView

Currency Comaprision

siddharthsoam — Wed, 25 Nov 2020 16:16:04 GMT

I have revenue in $. I need to divide this revenue in 3 categories that is tail(<$1 Mn),middle(1-5 Mn) and large(>5 Mn).

My script is as follows

Text(If(Revenue<1,'Tail',If(Revenue>5,'Large','Middle'))) as Account_type

I am comparing revenue with 1 that is a number not in currency format. This is giving me inaccurate results.

How can I compare revenue in currency format.

sunny_talwar — Thu, 13 Jul 2017 16:34:58 GMT

Try this

If(Revenue < 1,'Tail',

If(Revenue < 5, 'Middle', 'Large')) as Account_type

johnca — Thu, 13 Jul 2017 16:38:28 GMT

One way is

If(Revenue <= 1,'Tail,

If(Revenue > 1 And Revenue <= 5, 'Middle',

'Large'

)) as Account_type

HTH,

John

el_aprendiz111 — Thu, 13 Jul 2017 16:38:38 GMT

Hi,

if(Money(Revenue)<1......

Would you be able to share a sample with the expected output?

johnca — Thu, 13 Jul 2017 16:39:19 GMT

You're just too fast for me Sunny 🙂