Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Link Table

HI Expertise ...

Iam trying to create a Link table  it works for 2 fields .. and when i try to add more than  2 fields it gives me an error.

as shown in the attachment.

Is there any rule where  that only two fields can be created as link table ?

What if want to add Autonumber( for 4 fileds ) ?

How do i approach this ?

And also is there any way that i build a pplication and give it to a user and he ipens on his desktop ...aand he cannot reload the file nor can make any changes to the charts  and cannot dleete any of the charts on UI.. Is this possible ?

6 Replies
orguezfaccsa
Contributor II
Contributor II

Hi,

    I can't see any attachment

Best regards

smilingjohn
Specialist
Specialist
Author

Hi Oscar .. I have resolved the first  question ..If i want to add more than 2 fields then i have to use

Autonumber128( class,Student,Subject) as School,

Can you please answer my question..and it will be really helpfull if you can give me it with an example

orguezfaccsa
Contributor II
Contributor II

Hi John,

     when I've two or more fields, I concatenate them in a string and I use it as primary key. This way allows you to simplify connections between tables.

orguezfaccsa
Contributor II
Contributor II

‌Hi John,

    What do you don't understand? I see two tables, what is the problem?

smilingjohn
Specialist
Specialist
Author

Hi Oscar as you mentioned i have resolved the answer ..

I wanted to know about my second question ...

Is there a way to create a QVw file which cannot be reloaded nor can be the charts deleted from it

sudeepkm
Specialist III
Specialist III

Maybe you can ask users to download the QVW from AccessPoint in that case the script will be unavailable to reload and you can make the properties of the objects not to be altered using document > sheet > security and doc properties > security settings.