Discussion board where members can get started with Qlik Sense.
I have some KPI's
Instead of having to change the syntax every quarter to Q4 2018, Q1 2019, Q2 2019, etc...every quarter. Is there any way to have Qlik use the most recent automatically?
do u have a date fielD? month?
if u have a date field,
do as follow:
Example: IF my max (date) was 01/04/2018 and it's associated to Quarter 2018)
I do yes. I have the Quarter variable. I also have a date id (when people took the survey). So like 09/29/2018 - that format.
I've edited my previous messages; please try
Ok, I think I understand what the max date is judged on. But how does the beginning of the quarter get calculated? I see how it knows when the quarter ends, but not sure how it knows when it begins?