Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating custom dimensions

I have a requirement where I have data as

IDName
1Pa
1as
3asa
3wer
3asssc
2aaw

I Want a dimension that would be like Pro1 for ID as 1, Pro2 for ID as 2, Pro3 for ID as 3

8 Replies
MVP
MVP

Re: Creating custom dimensions

May be this as your calculated dimension:

Pick(ID, 'Pro1', 'Pro2', 'Pro3')

or

Pick(Match(ID, 1, 2, 3), 'Pro1', 'Pro2', 'Pro3')

or

'Pro' & ID

Not applicable

Re: Creating custom dimensions

I have around lakhs of ID's which would need me to add all the id and their respective names is there not a way where in the Names are give on the basis by grouping all the similar ID's as "Pro"+"id"

reddys310
Honored Contributor II

Re: Creating custom dimensions

Hi Shashank,

As you say that there are loads of records to modify, I would suggest you to do it in the load using an ApplyMap or simply make use of the last option which Sunny T mentioned in your load statement.

data:

Load 'Pro' & ID,

         name

       from ........

balrajahlawat
Esteemed Contributor

Re: Creating custom dimensions

may be like this?

load distinct *,

concat('Pro',ID) as ID

from

TableName;

Not applicable

Re: Creating custom dimensions

Is there no way to create a dimension itself and not performing data load for that dimension

MVP
MVP

Re: Creating custom dimensions

Yes there is and that way is to use a calculated dimension. If you don't want to use either of them, then I am afraid there is no 3rd way here.

reddys310
Honored Contributor II

Re: Creating custom dimensions

Hi Shashank,

I would suggest you to create the dimension in the load itself as that would improve your performance.

MVP
MVP

Re: Creating custom dimensions

I agree with Sangram

Community Browser