New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this solution

JonnyPoole
Former Employee
Former Employee

hi there,

try using 'SET'

SET  vMonthPrevious = MonthName(Today())-1;


also put $(vMonthPrevious) in a text/image object just to be sure its calculating the result in right format.


Even after using SET and reloading, you may still need some adjustments or interpretation/formatting functions to get the equivalence operation in the SET to work as you need.


Count({<Month={'$(vMonthPrevious)'}>}Products)

View solution in original post

Who Me Too'd this solution