topic Re: Create dimensions from min(id) in QlikView

Create dimensions from min(id)

oliver_henke — Fri, 30 Jun 2017 13:49:12 GMT

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

Re: Create dimensions from min(id)

sunny_talwar — Fri, 30 Jun 2017 15:37:42 GMT

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

Re: Create dimensions from min(id)

oliver_henke — Tue, 04 Jul 2017 08:57:29 GMT

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)

Re: Create dimensions from min(id)

balar025 — Tue, 04 Jul 2017 10:51:54 GMT

Hi,

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

Thanks

Ravi balar

Re: Create dimensions from min(id)

oliver_henke — Tue, 04 Jul 2017 13:21:15 GMT

Thank you Ravi, that helps