Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
hemanthaanichet
Contributor 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
MVP
MVP

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

PFA

7 Replies
MVP
MVP

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

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
Contributor III

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

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...

Highlighted
MVP
MVP

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

Please share a sample to work upon.

hemanthaanichet
Contributor III

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

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

MVP
MVP

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

Capture.PNG

hemanthaanichet
Contributor III

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

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

MVP
MVP

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

PFA