topic Re: compare periods in QlikView

compare periods

curiousfellow — Mon, 16 Nov 2020 15:15:19 GMT

Our admin_year runs from march 1 to march 1

People can enroll from 1 year before start admin_year to 1 year after start of admin_year

a table contains admin_year,date of enrollment and subscribernr for every enrollment

A subscriber can re-enroll for each year

I have a listbox containing weeknumbers This refers to a table with weeknumbers and enddate of that week for last admin_year (starting one year before start admin_year)

Now want a chart that compares the number of enrollments until a selected weeknumber

Admin_year is a dimension

My expression does not seem to work and I don't know why,

count(distinct{< weeknumber = , otherfield= {"= date_enrollment < addyears(weeknumbers.enddate, admin_year - last_admin_year"}>}subscribernr)

Re: compare periods

QFabian — Mon, 16 Nov 2020 15:52:24 GMT

Hi @curiousfellow , you can create a line chart using admin_year and weeknumber as dimensions, and one expression like 'count(subscribernr)', i can´t see why are you using set analysis, please explain.

Re: compare periods

curiousfellow — Tue, 17 Nov 2020 07:38:03 GMT

I want to select a weeknumber because the weeks of previous periods have passed, so for those years I have about 104 weeks while for example for this year 25 weeks have passed. Besides that I have more dimensions in my chart.

I want to show the values.