Create dimensions from min(id)

[oliver_henke]

Hi All,

I'm new to the Qlik Community. I'm trying some stuff in Qlik and I'm wondering if somebody could help me out.
Problem:

I would like to create Dimensions "Email1", "Email2" etc. where the minimum EmailID for CampaignId= Email1, second EmailID (for CampaignId) = Email2 etc. so I can group the different EmailId's into One Dimension.

CampaignID          EmailId     Measure1     Measure2       

1                         123               sum(..)                    sum(..)

1                         124               sum(..)                    sum(..)

1                         125               sum(..)                    sum(..)

1                         126               sum(..)                    sum(..)

2                         221               sum(..)                    sum(..)

2                         223               sum(..)                    sum(..)

2                         224               sum(..)                    sum(..)

etc.

Could someone help me out? Is this possible?

Thank you in advance,

Oliver

[sunny_talwar]

Are you looking to increment EmailId by 1 within a single CampaignID? Do this on the front end? Also, EmailIds are numbers?

[oliver_henke]

Hi Sunny,
EmailIds are numbers. I'm not trying to increment EmailId by 1 but trying to create a dimension so I can compare the first EmailId for each Campaign. in the example: I would like to see Meassure1 for EmailId 123 (CampaignId 1) and Emaild 221 (CampaignId 2)

[balar025 · Accepted solution]

Hi,

You can use firstsortedvalue (Measure1,EmailId) in expression.

Thanks

Ravi balar

[oliver_henke]

Thank you Ravi, that helps