topic Re: Expression only works if data is filtered in QlikView

Expression only works if data is filtered

Tue, 03 Jun 2014 07:32:10 GMT

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.

Re: Expression only works if data is filtered

johanlindell — Tue, 03 Jun 2014 07:42:48 GMT

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)

Re: Expression only works if data is filtered

tresB — Tue, 03 Jun 2014 07:45:03 GMT

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))