Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, I am new to Qlik and have a very simple table I am working on. My question is, in the table below, how would I have the second visit volume column show the previous month volume? So if I was filtered for June for example, how could I get the second column to show May? Thanks in advance.
Visit Type MonthYear Visit Volume Visit Volume
Flu Shot June 10 ?
Nurse Visit June 15 ?
The following function will set the field MonthYear to last month:
Sum({$<MonthYear = {$(=Month(AddMonths(Max(Date),-1)))}>} [Visit Volume])