Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
noman212
Creator III
Creator III

Asssigning fixed numbers to concatenated Fields

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

6 Replies
marcus_sommer

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

- Marcus

noman212
Creator III
Creator III
Author

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
Specialist II
Specialist II

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

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