Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I check synthetic key value

Hello Experts,

Is there any way to find value of synthetic for particular records.

Thanks & Regards,

Kiran Kokade

10 Replies
ramasaisaksoft

Hi Kiran,

            I hope u are asking values/Measures/Data for Synthetic keys/Fields .For this purpose you can go to

Table View->Right click on Synthetic table see the preview data for Synthetic keys.

Synthetic  table only shows the data for synthetic columns.

israrkhan
Specialist II
Specialist II

you can create Listbox on sheet.

or create tablebox, and add all synthetic fields .....

Anonymous
Not applicable
Author

That is my concern. I want to see value of synthetic key.

Anonymous
Not applicable
Author

From where you can get synthetic key fields

It is not there is list of columns.

Is there any special setting need to see this synthetic key fields?

israrkhan
Specialist II
Specialist II

there is no special settings,

1.PNG

Month and Region are Synthetic Keys

2.PNG

Table Box :

3.PNG

Hope it helps

Anonymous
Not applicable
Author

I want to see values what $ Syn 1 hold.

Is there any way to see that

israrkhan
Specialist II
Specialist II

try

= id &''& product in List Box,

it will show you what $ Syn 1 hold.

Not applicable
Author


As IsrarKhan wrote, it is the combination of the fields "Month" and "Region". If you want to see what the synthetic key represents, the use a listbox and select "<Expression>". Insert into the expression "=Month&Region". Thats your synthetic key.

Hope, that helps.

Anonymous
Not applicable
Author

Thanks for reply Imran.

So basically you are saying $ Syn 1 is holding concatenated string value.

then why we remove synthetic key and concatenate it  to avoid synthetic key.

if both are doing same thing.

Thanks & Regards,

Kiran Kokade