topic Select Not Null "OnActivateSheet" Trigger in QlikView

Select Not Null "OnActivateSheet" Trigger

Mon, 10 Mar 2014 04:29:44 GMT

Hi,

I want to select all not null value on activate sheet please help me how can i achieve this.

Re: Select Not Null "OnActivateSheet" Trigger

tresB — Mon, 10 Mar 2014 04:41:22 GMT

PFA

Re: Select Not Null "OnActivateSheet" Trigger

Mon, 10 Mar 2014 04:47:20 GMT

Great it works,

Thank you Tresesco.

Re: Select Not Null "OnActivateSheet" Trigger

rwunderlich — Mon, 10 Mar 2014 05:20:32 GMT

Wouldn't it be easier to user "*" as the Select In Field argument instead of the concat() expression? Or "?" if you wanted to exclude the blank?

-Rob

Re: Select Not Null "OnActivateSheet" Trigger

tresB — Mon, 10 Mar 2014 05:25:39 GMT

You are right Rob Wunderlich, however what I thought is there could be some blank values which appear to be null to the users and are not really so. To handle the case, I thought it would be better to use len(trim())>0.