topic Re: Data model change in QlikView

Data model change

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

Hi all,

I am facing the problem in requirement.

We have two different dimension used in two charts as dimension:-

Contractship to country,Equipmentshiptocountry both have same values :-

Now client if we select Contractship to _country , same selection should appear in ,Equipmentshipto_country chart..

Contractshipto_Country in SMA table
Equipmentshipto_Country in Equipmentshipto Customer

Both dimension are in different table.

let me know incase of further details

Pfa the snapshot of data model

Kind Regards

Manu

Re: Data model change

Marcos_rv — Thu, 07 Feb 2019 14:52:39 GMT

Hi how are you? mmmm I would try to add this field to the key, in both places, so you could be sure to be talking about the same in both tables. You'll have to play with the keys, but it's the way. Regards!!!

Re: Data model change

manu1512 — Thu, 07 Feb 2019 20:22:43 GMT

hi ,

i am good ,how are you doing ?

If possible can you pls elaborate with example?

Regards
Manu