topic Re: greater or equal to indirect analysis function in QlikView

greater or equal to indirect analysis function

Wed, 25 Nov 2020 16:16:04 GMT

I'm counting number of customers on a list. I have column of:

Id_customer

Date_of_subscription

Date_of_cancellation

in another seprated table, that is not connceted to the first one i hve list of dates

date_selected

Now i need to count id's that have Date_of_cancellation later than date_selected AND Date_of_subscription is older than date_selected

Now, I understand that with p or e functions base selections on selections in another filed. I'm trying to find greater or lesser in relation to what is in inidirect set analysis.

I was only successfull in equlizing:

count({<Date_of_cancellation=p([date_selected])>}id_customer)

In any case, besides different solution i need a syntax for >=/>/<=/< in p or e function.

=p(">=$(=date_selected)") doesn't return anything

Re: greater or equal to indirect analysis function

marcus_sommer — Wed, 04 Oct 2017 16:25:04 GMT

I think p() and e() aren't suitable in your case and that your expression should be more look like:

count({<Date_of_cancellation= {">=$(=max([date_selected]))">} id_customer)

- Marcus

Re: greater or equal to indirect analysis function

Thu, 05 Oct 2017 07:19:28 GMT

Thank you;

I have also managed to do it with with a p function.

They both give the same result, but it's useless for graphing, only good for KPI sort of display

My solution was

Count(

{$<

Date_of_cancellation=P({$<Date_of_cancellation={">$(=Date_selected)"}>}Date_of_cancellation),

Date_subscription=P({$<Date_subscription={"<$(=Date_selected)"}>}Date_subscription)

>}id_customer)