Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

Highlighted
Creator III
Creator III

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

Please share a sample to work upon.

Highlighted
Creator III
Creator III

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

Highlighted
MVP
MVP

Capture.PNG

Highlighted
Creator III
Creator III

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

Highlighted
MVP
MVP