topic Re: Replace String Value to Null in QlikView

Replace String Value to Null

sona_sa — Thu, 19 Jul 2018 11:23:13 GMT

Hi,

I have 2 field. Area Name and Area Date. Area Name is 3 value - A, B, and C. Area Date has also three date - 29, 30 and 31

Now I want Where Area Name is B, Assign the null value in Area Date where 30 is available.

Please let me know how to do through QlikView script by Load statement.

Thanks

Re: Replace String Value to Null

sunny_talwar — Thu, 19 Jul 2018 11:24:43 GMT

Now I want Where Area Name is B, Assign the null value in Area Date where 30 is available.

Assign null value in Area Date where 30 is available? What do you mean when you say 30 is available? can you support this with an example?

Re: Replace String Value to Null

sona_sa — Thu, 19 Jul 2018 11:33:42 GMT

Hi Sunny,

Please find the attached xls. I need all data with G column.

Thanks.

Re: Replace String Value to Null

sunny_talwar — Thu, 19 Jul 2018 11:34:48 GMT

What is the logic behind column G?

Re: Replace String Value to Null

sona_sa — Thu, 19 Jul 2018 11:38:42 GMT

Means wherever In %DRQ_REQ_NAME_IS_WP_LinkKey Field value is RFKPI>>S7.5-MILESTONE, RACE_CHART_WEEK_DATE = ' ' Means Blank, Whatever value is there, It should be null.

Thanks

Re: Replace String Value to Null

sunny_talwar — Thu, 19 Jul 2018 11:42:29 GMT

So, may be use WildMatch to search for the string RFKPI>>S7.5-MILESTONE

If(WildMatch(%DRQ_REQ_NAME_IS_WP_LinkKey, 'RFKPI>>S7.5-MILESTONE*'), Null(), RACE_CHART_WEEK_DATE) as RACE_CHART_WEEK_DATE_ OUTPUT

Re: Replace String Value to Null

sona_sa — Thu, 19 Jul 2018 12:04:41 GMT

While reloading

error is coming.

Thanks

Re: Replace String Value to Null

sunny_talwar — Thu, 19 Jul 2018 12:05:48 GMT

Can you share the script you ran?

Re: Replace String Value to Null

sunny_talwar — Thu, 19 Jul 2018 13:13:08 GMT

The error message response was the correct response? Really?