Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
idogridish2
Creator II
Creator II

Fixing a user count to a date and displaying the count on other months in the table

Hi All,

I am trying to fixate a user count to a specific date and displaying the count on other months in the table,

please find attached qvf and the excel (Data file),

the current table looks like this:

current table.pngand this is the expression:

Count(distinct {$<Date={"*01/03*"}>}UserID)

the required table should look like that:

Required table.png

i need to apply the count value from each *01/03* to 11 month ahead,

for example, the count of Mar-2020 should appear until Feb-2021

and the count of Mar-2021 should appear until Feb-2022.

after that i need to divide the terminations by those numbers for each month (there is a Termination_Flag in the qvf),

in the qvf you will find two tables,

1. headcount (this is the main issue i described above)

2. % Terminations (the final table)

i am looking for a dynamic solution.

please ask any question if needed,

i appreciate the help.

thanks.

Ido.

0 Replies