2 Replies Latest reply: Jul 26, 2017 11:19 AM by Justin McPheeters RSS

    Qlik Sense June 2017 - Dollar Sign Expansion Change

    Justin McPheeters

      Hi everyone,


      I'm not really sure if this is a bug or a correction of a bug, but wanted to see if anyone else is experiencing this issue.


      Previously I was using the first formula below to calculate the number of assets that were updated in the last month, but after upgrading to the June 2017 release I had to convert it to the second or third formula. It seems to be that quotes (single or double) placed inside of dollar sign expansions now interact with those outside of the expansion. Before, they were calculated within the dollar sign expansion and then the calculated value was placed within the exterior quotes.


      Qlik Sense 3.2.2

      Count({$ <[Asset Last Updated Date.Month] = {'$(=Year(Today(1)) & ' - ' & Date(Today(1), 'MMMM'))'}>} Distinct [AssetId])

      Qlik Sense June 2017 - 11.11.1

      Removing Single Quotes and Adding Chr(39)

      Count({$ <[Asset Last Updated Date.Month] = {$(=Chr(39) & Year(Today(1)) & ' - ' & Date(Today(1), 'MMMM') & Chr(39))}>} Distinct [AssetId])

      Replacing Single Quotes with Double Quotes

      Count({$ <[Asset Last Updated Date.Month] = {"$(=Year(Today(1)) & ' - ' & Date(Today(1), 'MMMM'))"}>} Distinct [AssetId])


      Any confirmations/explanations would be greatly appreciated.

      Best regards,