topic Re: count only non null values in QlikView

count only non null values

bhagi — Sat, 16 Nov 2024 17:59:01 GMT

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

Re: count only non null values

rubenmarin — Tue, 13 Oct 2020 06:39:47 GMT

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

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

Re: count only non null values

Chanty4u — Tue, 13 Oct 2020 08:38:07 GMT

Hi you can try this

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

Re: count only non null values

Brett_Bleess — Tue, 27 Oct 2020 15:53:44 GMT

@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