Beginner_Qlik1
Partner - Contributor III
2024-05-02
10:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error in expression
Hi,
I want to sum of all Values for which ValueCategoryGlobal are "06-CIP Cold Water Consumption" and "06-CIP Hot water Consumption" and BatchTypeGlobal starts with "CIP". What is worng with my expression.
Could somone help ?
2 Solutions
Accepted Solutions
maxgro
MVP
2024-05-02
10:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
for BatchTypeGlobal starts with "CIP" you can use
sum({$<BatchTypeGlobal={"CIP*"}>} Value)
521 Views
rwunderlich
Partner Ambassador/MVP
2024-05-02
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The BatchTypeGlobal modifier should be:
BatchTypeGlobal={"CIP*"}
-Rob
517 Views
4 Replies
BrunPierre
Partner - Master
2024-05-02
10:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do this in place of the WildMatch.
..., BatchTypeGlobal={"CIP*"}>} Value)
522 Views
maxgro
MVP
2024-05-02
10:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
for BatchTypeGlobal starts with "CIP" you can use
sum({$<BatchTypeGlobal={"CIP*"}>} Value)
522 Views
rwunderlich
Partner Ambassador/MVP
2024-05-02
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The BatchTypeGlobal modifier should be:
BatchTypeGlobal={"CIP*"}
-Rob
518 Views
Beginner_Qlik1
Partner - Contributor III
2024-05-03
03:22 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks all for your help.
452 Views