topic Re: How to force to select a value belong the data model -by selecting from a table that stands alone in QlikView

How to force to select a value belong the data model -by selecting from a table that stands alone

yanivvl0 — Sun, 03 Apr 2016 10:28:18 GMT

hi to all , i have a complicate model and in it i need to make a selection from stands alone field (table) A_year , the resault supose to be like i chose one of the fields from the model - YEAR_STATUS_DATE_1 , to be more clear - the expresion that in the textboxes must response to the selection ( you can see about the expresion in the prev discussion - https://community.qlik.com/thread/211520?sr=inbox)

THANKS.

Re: How to force to select a value belong the data model -by selecting from a table that stands alone

sunny_talwar — Sun, 03 Apr 2016 10:31:18 GMT

What would be a particular example? Lets say I select 2016 in A_year, then what would the text boxes (1 and 2) will be showing?

Re: How to force to select a value belong the data model -by selecting from a table that stands alone

yanivvl0 — Sun, 03 Apr 2016 10:55:54 GMT

SOMETING LIKE THIS :

Re: How to force to select a value belong the data model -by selecting from a table that stands alone

sunny_talwar — Sun, 03 Apr 2016 10:58:29 GMT

Try these expressions:

=Sum({<P_NO_1=P({<STATUS_1={90}, YEAR_STATUS_DATE_1={'<$(=Max(A_year))'}>}P_NO_1), YEAR_STATUS_DATE_1={'<$(=Max(A_year))'}>}

Aggr(FirstSortedValue({<YEAR_STATUS_DATE_1={'<$(=Max(A_year))'}>}UnitsForMetsai, -YEAR_STATUS_DATE_1),P_NO_1))

=Sum({<P_NO_1=P({<STATUS_1={90}, YEAR_STATUS_DATE_1={'<$(=Max(A_year)-1)'}>}P_NO_1), YEAR_STATUS_DATE_1={'<$(=Max(A_year)-1)'}>}

Aggr(FirstSortedValue({<YEAR_STATUS_DATE_1={'<$(=Max(A_year)-1)'}>}UnitsForMetsai, -YEAR_STATUS_DATE_1),P_NO_1))

Re: How to force to select a value belong the data model -by selecting from a table that stands alone

yanivvl0 — Mon, 04 Apr 2016 04:17:16 GMT

hi Sunny , We usually know what can be the solution to various problems, but your magic touch he finishes the job ... - Many thanks again !!