topic Re: Using Or function in QlikView

Using Or function

Mon, 07 Jul 2014 16:06:32 GMT

hi All,

Can you please tell me if the below syntax is correct? I am trying to use or and like condtion together

count({<Officeaddress ={"*Delhi*","* New Delhi*","*Old Delhi*"}>} Transaction_id)

vardhancse — Mon, 07 Jul 2014 16:08:58 GMT

why cant u use only one condition

=count({$<Officeaddress={'*Delhi*'}>}(Transaction_ID))

as its a wild card search it will take all the data which contains delhi

Mon, 07 Jul 2014 16:15:41 GMT

Sorry i missed actually I need to check ND as well

vardhancse — Mon, 07 Jul 2014 16:20:44 GMT

as its a wild card search it will give u the count of transaction Id which contains office address *delhi*.

Mon, 07 Jul 2014 16:27:22 GMT

Hi Sai,

Thanks foy your help but some people have written Delhi as ND so i want to pass ND as well in or condtion

Mon, 07 Jul 2014 16:47:19 GMT

So wouldn't you just add 'ND'

count({<Officeaddress ={"*Delhi*","* New Delhi*","*Old Delhi*", 'ND'}>} Transaction_id)

Marcio_Campestrini — Mon, 07 Jul 2014 16:56:38 GMT

Hi Sasi.

And what if you change the ND to New Delhi in the script, putting a condition in the script?

vardhancse — Mon, 07 Jul 2014 16:58:12 GMT

hi you can use applymap function for ND to New Delhi

Applymap('CD',Officeaddress) as Officeaddress,

we can use excel sheet to get description from code