Asssigning fixed numbers to concatenated Fields

[noman212]

Hi Commnity,

I am using a table :

Table A :

ID,

A,

B,

C

from table A.qvd(qvd);

form Table A i used 2 fields as a key like given below:

Table A :

ID & A as KEY,

A,

B,

C

from Table A.qvd(qvd);

now from concatenated key i have the vaues ike this

1A

2B

3C

4D and so on..

now the question is here.

I want to assign fixed numbers that cannot be changed for any reason

let suppose if 2B is assigned to number 2 so it cannot b changed to 1 or 3 or any other number either 2B is present in the table or not.

i used these table as a dimension table.

KEY , Number

1A , 1

2B ,  2

3C , 3

4D , 4

Please suggest.

Regards

Noman khan

[marcus_sommer]

What is the aim for doing this? What do you do with this Number?

- Marcus

[noman212]

Thanks for the reply Marcus.

i would use this for Optimization Purpose.

i will use in expression, currently facing unresponsive behaviour when selection multiple years data.

[lakshmikandh]

Try these functions in load script,

Counter functions ‒ Qlik Sense

[Anil_Babu_Samineni]

After read this, Still confusing. Can i know your intend. And let me know what is the purpose you are doing this?

[tresesco]

Try with autonumber() like:

Table A :

AutoNumber(ID & A) as KEY,

A,

B,

C

from Table A.qvd(qvd);

[marcus_sommer]

I don't believe that you will get a performance improvement with this approach. It's more likely to optimize the application if you replaced your combined-key with an autonumber-key or even more effectual to merge these tables to avoid those key (probably within a linktable-model) and reducing the temporary calculation-tables, see: Logical Inference and Aggregations.

- Marcus