Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Goodman_UPS
Contributor II
Contributor II

Creating a Measure from a Dimension

I have a dimension that I created called Proposed Bucket.

Here is my if statement:

=If(Excp_Category='6-Attempted','2-CUSTOMER ACTION',
if(Excp_Category = '1-Manifest','5-APPLE ACTION',
    If(Excp_Category='5-Out for Delivery','3-OUT FOR DELIVERY',
    if(Current_Scan_Activity_Record_Type='Out For Delivery','3-OUT FOR DELIVERY',
    IF(Excp_Category='7-Delivery','1-DELIVERED', [Exception_Resolution_Proposed_Bucket])))))
 

I want to create a measure that adds up certain elements of this proposed bucket. 

Labels (1)
3 Replies
BrunPierre
Partner - Master
Partner - Master

Sum({$<[Proposed Bucket]={'2-CUSTOMER ACTION','1-DELIVERED'}>} Measure)

Goodman_UPS
Contributor II
Contributor II
Author

I get error in expression when used.

BrunPierre
Partner - Master
Partner - Master

It was simply an example that needed to be adjusted to reflect field names in the model.

Perhaps you could post a sample of the dataset.