topic counting where date < calculated date in QlikView

counting where date < calculated date

curiousfellow — Fri, 19 Oct 2018 10:21:03 GMT

I have a dimension called yearsubcribe.

In a listbox I select a date (date_sel).

Now I want to count clients who subcribed before month and day of date selected .

It it possible that clients subcribe in year before year of subcription.(so daynumber of year won't work)

So I constructed this expression:

count ( distinct {< date_subcription ={"<= date(date(date_sel,'DD')&'-' & date(date_sel,'MM')& '-' & text(yearsubcribe),'DD-MM-YYYY')"}>} clientid)

Is it not possible to use a dimension value in this expression or

do i make another mistake ?

Re: counting where date < calculated date

andrey_krylov — Fri, 19 Oct 2018 11:00:06 GMT

Try this

count ( distinct {< date_subcription ={"$(='<=' & date(date(date_sel,'DD')&'-' & date(date_sel,'MM')& '-' & text(yearsubcribe),'DD-MM-YYYY'))"}>} clientid)

Re: counting where date < calculated date

curiousfellow — Fri, 19 Oct 2018 11:12:05 GMT

Seems to work, Thnx

Is missed a bracket, but besides and went wrong with this piece ={"$(='<='

Re: counting where date < calculated date

andrey_krylov — Fri, 19 Oct 2018 11:20:37 GMT

Just syntax error)