topic Re: Need help on Script in QlikView

Need help on Script

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

Hi Community,

Please could you explain below script.. someone has made this..

IF(IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC', IF(Category='CAR',( Category *1),
IF(Category ='BUS',( Category *3.1),'')),'') as CategoryNew

Regards,

Paul

Re: Need help on Script

Anil_Babu_Samineni — Thu, 29 Nov 2018 09:42:21 GMT

Like way?

IF(IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC', IF(Category='CAR',( Category *1),
IF(Category ='BUS',( Category *3.1),'')),'') as CategoryNew

Blue part, Will understand the condition fulfill or not. That means, First it will effect to show OR operator then AND operator. If condition fulfill show ABC else Null. IF((Category='CAR' Or Category='BUS') And Category >10,'ABC','')='ABC' If this condition returns either ABC or Null. Then represent only ABC values. same as next one. You may bifurcate and do some analysis. Else, Ask use if anything not understandable.

Re: Need help on Script

jfkinspari — Thu, 29 Nov 2018 10:29:19 GMT

I think the Category field i Dual, so it consists of both a string and a number. That could explain why the formel uses both string and number condition on the same field

In the end it multiplies Catagory as with 1, if its a CAR, and if's a bus multiplied with 3,1.