0 Replies Latest reply: Jul 4, 2017 7:50 AM by Ozgur Cirak RSS

    Qlik Sense Desktop Data manager calculated dimension

    Ozgur Cirak

      Hello ;

       

      I'm trying to add a new dimension to my table. I have date values and im trying to add periodical values as months. For example 01.01.2017 to 31.01.2017 as January etc.

       

      When i'm using calculated dimension in master items in the app below formula works,

      if([Sales.Date] >='01.01.2017' and [Sales.Date]<='31.01.2017','Jan',if([Sales.Date]>'31.01.2017' and [Sales.Date]<='28.02.2017','Feb',if([Sales.Date]>'28.02.2017' and [Sales.Date]<='31.03.2017','March',if([Sales.Date]>'31.03.2017' and [Sales.Date]<='28.04.2017','April'))))

       

      But when i try this from data manager, it says that '>' or '<' cant be recognized.

       

      Why is this happening? stalwar1