6 Replies Latest reply: Feb 28, 2018 4:06 AM by Pablo Labbe RSS

    Usage of brackets around date field in Monthstart function

    Bram de Kort

      Hi all,

       

      I encountered a strange behavior of the Monthstart function in Qlik Sense. Hope one of you can clear this mystery for me :-).

       

      I made a Master (drilldown) dimension called 'Besteldatum' (Orderdate in English) with the following expression:

       

      =Dual(Year([Besteldatum])&'-'&Month([Besteldatum]), monthstart(Besteldatum))

      =Dual('week'&Num(Week([Besteldatum]),00),Num(Week([Besteldatum]),00))

       

      Using this dimension in a bar chart together with a count on ordernumbers, it looks like this when drilled down to week level:

       

      Week view.JPG

       

      Then, when I make the following minor change to the master dimension (including the square brackets around the field 'Besteldatum' in the function monthstart, the same bar chart (using the same month selection as above)) looks like this:

       

      =Dual(Year([Besteldatum])&'-'&Month([Besteldatum]), monthstart([Besteldatum]))

      =Dual('week'&Num(Week([Besteldatum]),00),Num(Week([Besteldatum]),00))

       

      Week view (brackets).JPG

       

      Does anyone know about this? Is this maybe a bug?

       

      Thanks in advance for your response!

       

      Bram