topic Data is not behaving properly in QlikView

Data is not behaving properly

smilingjohn — Sun, 07 Mar 2021 07:24:51 GMT

Hi All ,

Please refer my data screenshot below after loading the file . now if you look for the field FeatureID i have Empty and for the field Feature there is just a dash,

How can I replace the dash (-) under Feature column by looking at the TeamID . Thanks

Thanks in Advance

Re: Data is not behaving properly

Saravanan_Desingh — Sun, 07 Mar 2021 00:24:53 GMT

The '-' seems to be NULL. So, you can check for the Null and replace it.

If(IsNull(Feature),'ReplaceMe',Feature)

Re: Data is not behaving properly

Saravanan_Desingh — Sun, 07 Mar 2021 00:48:06 GMT

Oh sorry. I thought you will replace it with whatever you want.

If(IsNull(Feature),FeatureID,Feature)

Re: Data is not behaving properly

smilingjohn — Sun, 07 Mar 2021 07:24:34 GMT

Hi Saran,

I want to replace the null value by the Feature number as shown in the screenshot below

the highlighted blue mark should get filled up by the FEA53118 for TeamID 56441371075 and similarly

and so on ....I hope I tried to explain . I know this is very complicated but need some help from you

Re: Data is not behaving properly

Saravanan_Desingh — Sun, 07 Mar 2021 01:08:39 GMT

Oh I got it. Can you upload the sample file please?

Re: Data is not behaving properly

smilingjohn — Sun, 07 Mar 2021 07:24:13 GMT

Hi Saran ,

PLease find the attachment of the qvw file

Thanks

Re: Data is not behaving properly

Saravanan_Desingh — Sun, 07 Mar 2021 02:22:26 GMT

Sorry I could not open your file. Because I am using PE. But please check the solution below.

tab1: LOAD TeamID, FeatureID, If(Len(Trim(Feature))=0,Peek(Feature),Feature) As Feature; LOAD * INLINE [ TeamID, FeatureID, Feature 5212700, REGRESSION, FE5318 5212700, EMPTY, 50825165, TF1, FE496 50825165, EMPTY, ];