same day last year expression

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

Hi All,

I need some help with a problem I am trying to solve.

I am trying to

--count distinct People_ID for the selected year, selected Pay_period and on the Max Number_day which from user selection. (works fine) =count({$< Number_Day={'$(=$(vMaxDay))'} >}(People_ID))

--Count People_id for the previous year of the selected year but for the same Number_Day as currently selected year and disregarding Pay_Period selection.

Example:

For the above data in excel file. Below is the current selection.

=count({$< Number_Day={'$(=$(vMaxDay))'} >}(People_ID)) Result 3

$vMaxDay=6

Previous year from my calculation

=count({$< Year={$(=Year-1)},pay_period=, Number_Day={'6'} >}DISTINCT(People_ID))

And Result of count should be 1.

I added 6 manually. It’s basically max Number_Day of the current selection. Number_Day has to be dynamic.

Appreciate your help

Regards

Saif

Re: same day last year expression

Claudiu_Anghelescu — Mon, 05 Aug 2019 15:14:49 GMT

=count({< Year={$(vPrevYear)}, Pay_Period=, Number_Day={$(vMaxDay)} >}DISTINCT(People_ID))

topic same day last year expression in QlikView

same day last year expression

Re: same day last year expression