topic Help in Designing Model in QlikView

Help in Designing Model

Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have a data model like below sample .i need to create a association between fact 1 and fact 2

[CALL NAME] should link with EID, [A Name] should link with columns of fact 2 tables .

And data should not be duplicated based on Account id

Kindly suggest me the way .Please find the sample attachment

Thanks in advance.

Re: Help in Designing Model

MK9885 — Thu, 10 Nov 2016 18:08:06 GMT

Hi,

Please find the attached qvw and let me know if this is what you looking for? We can further optimize it but as you wanted to link particular fields.

Thanks.

Re: Help in Designing Model

Fri, 11 Nov 2016 07:03:34 GMT

Hi Arvind,

I want to link fact 1 and fact 2 tables.And we are using link table in our model.

suppose if we select call name it shoud link with Eid. we need a count of Eid for particular call name.

and if we select call name it should link to account id only from fact 2 table .we need a account id count for particular call name from fact 2 table

Thanks

Re: Help in Designing Model

Anonymous — Fri, 11 Nov 2016 12:01:20 GMT

Try this

Re: Help in Designing Model

MK9885 — Fri, 11 Nov 2016 16:12:54 GMT

We can make the fields link with each other but the question is what should be the count for EID and Account ID after linking (it will be 1 in most case)?

Please find the attachment.