Qlik Sense Desktop Data manager calculated dimension

Anonymous — Tue, 04 Jul 2017 11:50:44 GMT

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‌

topic Qlik Sense Desktop Data manager calculated dimension in App Development

Qlik Sense Desktop Data manager calculated dimension