5 Replies Latest reply: Apr 10, 2017 6:24 AM by Andrey Khoronenko RSS

    Using Set Variable in Set Analysis Qlik Sense

    Samuel Lin

      Hello Qlikers,

       

      I have two tables, for simplicity:

       

      Events:

      EmailAddress

      EventName

      EventStartDate

      EventEndDate

       

      Transaction:

      EmailAddress

      OrderDate

      Revenue

       

      In my script I have these two lines:

      Set vEventEndDate = Date(EventEndDate);

      Set vEventStartDate = Date(EventStartDate);

       

      In the table I want to calculate things such as

       

      count({<OrderDate={'>$(vEventEndDate)}>} distinct EmailAddress), I got invalid expression, ad I have tried several way to add $ signs, but still no luck.

       

      Could someone please guide me?

       

      Thanks,

      Samuel