8 Replies Latest reply: May 14, 2016 3:22 AM by youssef lachgar RSS

    Force a Last Month Selection for a specific Chart

    youssef lachgar

      Hi Guys,

       

      It's been 4 days i try to find a solution to this issue without success (I am using Qlik Sense addon from Sysaid Cloud App).

      I try to force a Month and Year selection what ever the user is selecting.

       

      It should be setup as "Last Month",  so the data show in the global view could be modify but it will not affect this chart like that :

       

       

      BI Tools 2.PNG

       

      In the Mesure expression i specified :

       

      Count({<ACCOUNT_ID={$(vCompany)},Request_Month=${(=Month(AddMonths(Max(Date),-1)))},Request_Quarter=,Request_Year=>}distinct(request_user_username))

       

      I know that i can specify the Year and Month Manually like that :

       

      Count({<ACCOUNT_ID={$(vCompany)},Request_Month=,Request_Quarter=,Request_Year={'2016'}>}distinct(request_user_username))


      But i want to do it compare to curent Month (TodayMonth) ... sorry for my poor knowledge but i am a little bit lost here.