Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Select Not Null "OnActivateSheet" Trigger

Hi,

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Select Not Null "OnActivateSheet" Trigger

PFA

4 Replies
MVP
MVP

Re: Select Not Null "OnActivateSheet" Trigger

PFA

Not applicable

Re: Select Not Null "OnActivateSheet" Trigger

Great it works,

Thank you Tresesco.

Re: Select Not Null "OnActivateSheet" Trigger

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

MVP
MVP

Re: Select Not Null "OnActivateSheet" Trigger

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.

Community Browser