topic Help required in replacing the text in QlikView

Help required in replacing the text

Anonymous — Thu, 26 Mar 2015 09:32:36 GMT

Hi All,

Please see the highlighted condition which will give the data from the sentence NUMBER OF INFECTIONS. But If there is a sentence as NUMBER OF INFECTIONS in the column DESCRIPTION then the malware name has to be Multiple Malware Name

If(Index(Description,'infections'),TextBetween(Description & '#','Number of infections:','#'),If(Index(Description,'Malware name:'),TextBetween(Description & '#','Malware name:','#'),TextBetween(Description & '#','Malware Name:','#'))) As [Malware Name],

Re: Help required in replacing the text

anbu1984 — Thu, 26 Mar 2015 09:38:08 GMT

So if you have infections in Description field, you want to assign constant string "Multiple Malware Name" to [Malware Name]??

Re: Help required in replacing the text

Anonymous — Thu, 26 Mar 2015 09:46:27 GMT

Hi Anbu,

Thanks for replying.. Actually this script is made by you. Thanks again.

The actual script given by you is If(Index(Description,'Malware name:'),TextBetween(Description & '#','Malware name:','#'),TextBetween(Description & '#','Malware Name:','#')) As [Malware Name]

In some cases I dont have Malware name or Malware Name. Instead I am having 'Number of infections: 2'

So I made a script like below.

If(Index(Description,'infections'),TextBetween(Description & '#','Number of infections:','#'),

If(Index(Description,'Malware name:'),TextBetween(Description & '#','Malware name:','#'),TextBetween(Description & '#','Malware Name:','#'))) As [Malware Name]

As a result I am getting 2 in the Malware Name column which is actually correct. But instead of 2 I want that to be 'Multiple Virus'

Re: Help required in replacing the text

anbu1984 — Thu, 26 Mar 2015 09:55:40 GMT

Instead of TextBetween(), then hardcode the value.

If(Index(Description,'infections'),'Multiple Virus',

If(Index(Description,'Malware name:'),TextBetween(Description & '#','Malware name:','#'),TextBetween(Description & '#','Malware Name:','#'))) As [Malware Name]

Re: Help required in replacing the text

Anonymous — Thu, 26 Mar 2015 10:14:17 GMT

No words to express. That simple?

It is working perfectly... Thanks a ton..