2 Replies Latest reply: Apr 22, 2015 5:37 AM by adam linden RSS

    Attempting to create an active flag

      Hi, I just started using Qlik Sense and I'm trying to create an active flag filter that can mark a post as either active or inactive depending on what dates it's is set to activate between.
      I've attempted to do this by importing an excel file that contains todays date and I'm pulling the activation/deactivation dates from a database. I'm not very familiar with how the code in Qlik Sense works so I tried some VERY basic solutions to my problem, the main one being:

      if (TodaysDate > VALIDFROM and TodaysDate < VALIDTO, FlagActive = 1)

      I'm attempting to do this so that I can show only  active or inactive users.

       

      Apologies for somewhat poor english, it isn't my main language.

       

      Thank you in advance