topic Re: (P) / (E) in Set Analysis in QlikView

(P) / (E) in Set Analysis

tmumaw — Sat, 16 Nov 2024 01:45:21 GMT

Trying to use the (P) and having problems. Any idea what might be wrong with this? What I am trying to achieve is to count the number of customers in all years.

Thanks

Count(DISTINCT{$<StartYear_Ind = {1},[Sold To] = P({1<[Valid To Year]={$(=$(vCYear) - 2)}>})*P({1<[Valid To Year]={$(=$(vCYear) - 1)}>})>} [Sold To] )*P({1<[Valid To Year]={$(=$(vCYear) - 0)}>})>} [Sold To] )

Re: (P) / (E) in Set Analysis

sunny_talwar — Fri, 06 Dec 2019 18:48:20 GMT

May be this

Count(DISTINCT {<StartYear_Ind = {1}, [Sold To] = P({1<[Valid To Year] = {$(=$(vCYear) - 2)}>}) * P({1<[Valid To Year] = {$(=$(vCYear) - 1)}>}) * P({1<[Valid To Year] = {$(=$(vCYear) - 0)}>})>} [Sold To])

Re: (P) / (E) in Set Analysis

tmumaw — Fri, 06 Dec 2019 19:02:08 GMT

Thanks Sunny. That worked perfectly. Have a great weekend.