ignoring selections in set analysis in text box

hathwarjaya — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am stuck in one thing and not been able to solve it.

I need to ignore selections in the following expression where i calculation the data for last 7 days but even after putting 1 in the set it does not work.The set analysis expression is in the text box

=count({1<CHANNEL={sales},Date2={">=$(=Date(max(Date2)-7))"}>}ticket_ID)

Please help

Thanks & Regards,

Jaya

Re: ignoring selections in set analysis in text box

tresB — Wed, 04 Apr 2018 10:49:24 GMT

Selection ignorance has to be there in all aggregation functions. You haven't used it in max(). Try like:

=count({1<CHANNEL={sales},Date2={">=$(=Date(max({1}Date2)-7))"}>}ticket_ID)

topic ignoring selections in set analysis in text box in QlikView

ignoring selections in set analysis in text box

Re: ignoring selections in set analysis in text box