Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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
tresesco
MVP
MVP

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