topic Re: Link Table in QlikView

Link Table

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Link Table

orguezfaccsa — Mon, 23 Oct 2017 12:57:04 GMT

Hi,

I can't see any attachment

Best regards

Re: Link Table

smilingjohn — Mon, 23 Oct 2017 13:03:23 GMT

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

Re: Link Table

orguezfaccsa — Mon, 23 Oct 2017 13:09:15 GMT

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.

Re: Link Table

orguezfaccsa — Mon, 23 Oct 2017 14:24:33 GMT

‌Hi John,

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

Re: Link Table

smilingjohn — Mon, 23 Oct 2017 15:52:57 GMT

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

Re: Link Table

sudeepkm — Mon, 23 Oct 2017 15:58:11 GMT

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.