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: 
hemanthaanichet
Creator III
Creator III

How can I reflect the second datamodel with respective selection of first datamodel

Hi All

I have scenario like i have two data models. Both the data models are same but the table name & column names are different. if i select the first data model year & month for that year & month my second data model has to reflect and has to display the values as per the selection

Note: Both data model could not be  linked.

for example:

DataModel 1

Year , Month

Sum ({<Year={$(=max(Year))}, Month=>}Sales)

Datamodel 2

Year1 , Month1

Sum ({<Year1={$(=max(Year1))}, Month1=>}Sales1)

Regards

Hemanth

1 Solution

Accepted Solutions
7 Replies
tresesco
MVP
MVP

Way1: Use field event trigger to select other model field on one's selection

Way2: Refer other model field in the expression like:  Sum ({<Year1={$(=max(Year))}, Month1=>}Sales1)


Now, here you have to decide on which model field Year1/Year would be referred when.

hemanthaanichet
Creator III
Creator III
Author

thanks Tresesco ..

way 2 is not working properly it refelects but the values are not matching....

can pls say the way 1 with a example plsss...

tresesco
MVP
MVP

Please share a sample to work upon.

hemanthaanichet
Creator III
Creator III
Author

sample data but give any expression ...... so it easy to start from the base

tresesco
MVP
MVP

Capture.PNG

hemanthaanichet
Creator III
Creator III
Author

yeah this working but best way is event trigger if u dnt mine could pls do a sample for me pls.....

tresesco
MVP
MVP

PFA