Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

GetSelectedCount, but only those which nas not null in some other field.

I want to divide by number of selected values in some field, like GetSelectedCount(Customer). But if the selected Customer has null in some other Field, like in Sales_Amount, it should be excluded, even if he is selected.

Do you have some suggestions?  Thank you.

1 Reply
Highlighted

Re: GetSelectedCount, but only those which nas not null in some other field.

May be use Count() instead?

Count({<Sales_Amount = {'*'}>}Customer)

or this

If(GetSelectedCount(Customer) > 0, Count({<Sales_Amount = {'*'}>}Customer))