Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to select all not null value on activate sheet please help me how can i achieve this.
Go to Solution.
Great it works,
Thank you Tresesco.
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?
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.