topic Re: If condition in QlikView

If condition

krish2459 — Sat, 16 Nov 2024 00:21:35 GMT

Hi,

I'm trying to use the below condition as a dimension.

It's not working.

=if([Primary Business Use]=5 ,
if( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<3,'Fail','Okay'))

Thanks..

Re: If condition

krish2459 — Wed, 08 Jul 2020 11:05:11 GMT

Hi,

Please let me know how to correct it.

Thanks..

Re: If condition

sunny_talwar — Wed, 08 Jul 2020 11:23:34 GMT

The syntax look right... Does this give you an error message when you use this as a dimension?

Re: If condition

krish2459 — Wed, 15 Jul 2020 16:40:27 GMT

Yes It is correct Sunny.

Acutauuly there was syntax error in my expression.

I'm have other issue and I'm using the same thread.

It is also belongs to if condtion.

Below is the condition.

If(MATCH(trim(Upper("Main Usage")), 'SALES', 'OFFICE', 'SERVICE','OTHER')
,'Sales, Office, Service','R&D, Logistics, Manufacturing') as "Primary Business Use Description"

Here one more new enttry as added in the "Main Usage" category as "LAND".

The above condition should satisfy also we need to disply "LAND" as well.

Final Out PU sees to be:

"Main Usage":

"LAND"

"Sales, Office, Service"

"R&D, Logistics, Manufacturing"

Thanks..

Re: If condition

sunny_talwar — Wed, 15 Jul 2020 19:38:41 GMT

May be this

If(Upper("Main Usage") = 'LAND', Upper("Main Usage"), If(Match(Trim(Upper("Main Usage")), 'SALES', 'OFFICE', 'SERVICE', 'OTHER'), 'Sales, Office, Service','R&D, Logistics, Manufacturing')) as "Primary Business Use Description"