topic Re: Remove Numbers With No Data in QlikView

Remove Numbers With No Data

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

I'm sure this is a quick fix, but I've made a chart with some data tying out to part numbers; QOH1, Min1, Max1, Sales1.

I want to remove the part numbers (%FEL) that have no data in the columns listed above. I've tried doing purgchar in the script and it didn't work.....not sure if I've made some sort of mistake or is there another way of doing this?

Please see attachment.

Thanks!

Re: Remove Numbers With No Data

jcampbell474 — Wed, 23 May 2018 17:31:28 GMT

I might be over simplifying this, but I checked your data. If QOH1 is null the other columns are null, too. So, if you go into properties and check the Suppress When Value is Null checkbox, the results should be what you're looking for.

HTH,

Jason

Re: Remove Numbers With No Data

oliveton — Wed, 23 May 2018 19:08:08 GMT

Awesome, this is exactly what I needed!

I knew someone with more experience would be able to find a simple solution without me clicking around for 2 hrs.

Thanks a bunch!

Re: Remove Numbers With No Data

vishsaggi — Wed, 23 May 2018 21:20:58 GMT

Hi Natalie, please close the thread marking correct/helpful responses if you got the resolution.

Thanks,
V.

Re: Remove Numbers With No Data

jcampbell474 — Thu, 24 May 2018 13:24:17 GMT

You're very welcome, Natalie. Glad I could help.

As Vishwarath stated, please close the thread by marking the correct response.

Hope you have a great day!