Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bhagi
Contributor II
Contributor II

count only non null values

Hi all,

I want to  find the last non NULL value in a Field  without any dependency on current selection

 

im using below expression but not working..

=Max({<[prodcut]={"<>ISNULL()"}>} Year)

 

thanks 

bahgi

Labels (4)
3 Replies
rubenmarin

Hi, I think you are looking for: =Max({<[product]={"*"}>} Year)

It will return the max year that has any value in product field.

Chanty4u
MVP
MVP

Hi you can try this

=Max({<Product={"<>ISNULL()"},Year=>} Year)

Brett_Bleess
Employee
Employee

@bhagi yet another post where you have multiple responses, please be sure you return to your threads and use the Accept as Solution button on the post(s) that helped you resolve your issue, as this is how the posters get credit for the help they provide to the Community, and it also confirms to other members what actually worked, so please be sure you return to your posts and close them out if at all possible.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.