
Anonymous
Not applicable
2017-07-04
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- calculated dimesion
395 Views
0 Replies
