Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Qlik Sense Desktop Data manager calculated dimension

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

Tags (1)