
Creator
2024-04-01
02:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to use bith max string and concat expressions in one dimention
Hi All,
good day,
can you please help how to used below both conditions to use in single dimension., if use single condition it is working but if i combine both with "and " i am getting invalid Dimension. and i am giving this condision in Group dimension
Aggr(MaxString([Location]),[Industry])
and
aggr(Concat([Industry], ','), [Master Number])
the above contion is to get below scenario
Master Number | Master Name | Contract Number | Location | Group |
1137 | EXOR | 99698 | Italy | Automotive,Comms & Media,Not Available,Utilities |
Labels (8)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
dimension
-
expression
-
General Question
-
Qlik Sense
-
Script
-
Set Analysis
1,455 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
11 Replies

Contributor
2024-04-04
02:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[image: image.png]
Like this one Output below table. Please help me
Like this one Output below table. Please help me
262 Views

MVP
2024-04-04
04:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't see any image.
If you want help you need to provide more info of what are you trying. Which result do you get? if there are differences it could be because your real data is different than the sample data provided
253 Views

- « Previous Replies
-
- 1
- 2
- Next Replies »