Expression only works if data is filtered

[#1]

Hi,

I have the following expression which seems to only show data if the data is filtered down to 1 account.  If I "clear" the selections, it shows no data:

Count({<DeliverDate = {">$(=CurrentEntitlementStartDate)"}>}distinct CSP_Name)

Is it due to the type of chart/table i have selected in qlikview?

I have attached the qvw file.

Thanks for any help.

Cheers.

[johanlindell]

WIth no filter set you will get many "rows" back and hence this can not be evaluated to a string. Us e a function like Min or Max to select the date you want.

Count({<DeliverDate = {">$(=Min(CurrentEntitlementStartDate))"}>}distinct CSP_Name)

[tresesco · Accepted solution]

Set Analysis doesn't work row-wise. When you use Delivery Date as a dimension and want the output to be based on row values, it doesn't work so. Deliver Date used in set analysis has already filtered the data based on available scoped data before entering into chart dimension. You rather have to use If in that case like:

=Count(distinct If(DeliverDate >CurrentEntitlementStartDate, Account & CSP_Name))