kaoaoa
Contributor
2020-07-20
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Invalid dimension in table using calculated dimension
Hi everyone,
I'm trying to make a calculated dimension which defines if, on a specific date, the shop was opened or it wasn't. If i add this as a dimension to a table it says 'invalid dimension'
This is my formula:
if (Weekday <> 'Sun', 'Open', if (Count(distinct{$<Type = {'O','N','A','S','D','L','C','B'}>} TransactionID)>5, 'Opened', 'Closed')
already tried using Aggr, but that also doesn't seem to work
Thanks in advance!
456 Views
1 Reply
Qlik1_User1
Specialist
2020-07-22
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
formula seems to be correct but missing oneclosing bracket
if (Weekday <> 'Sun', 'Open',
if (Count(distinct{$<Type = {'O','N','A','S','D','L','C','B'}>} TransactionID)>5, 'Opened', 'Closed')
)
416 Views