Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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?
SOMETING LIKE THIS :
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))
hi Sunny , We usually know what can be the solution to various problems, but your magic touch he finishes the job ... - Many thanks again !!