Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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

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