Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi again to all members , i have to say that i am getting from you great help and also learn the important attitude how to see things and solve problems - Thanks !
i have Another requirement for the customer - in addition to what the previous discussion deceased see https://community.qlik.com/thread/211350?sr=inbox
i have to make all the calculation also to the previous year which is selected , so , if i select 2015 i need to show in one textbox all the calculate Relating to the years before 2015 - this is the current situation , AND in the seccond textbox i need to show exactly the same thing but like i chose the year 2014 , thanks.
May be this:
=Sum({<P_NO_1=P({<STATUS_1={90}, YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}P_NO_1), YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}
Aggr(FirstSortedValue({<YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}UnitsForMetsai, -YEAR_STATUS_DATE_1),P_NO_1))
May be this:
=Sum({<P_NO_1=P({<STATUS_1={90}, YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}P_NO_1), YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}
Aggr(FirstSortedValue({<YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}UnitsForMetsai, -YEAR_STATUS_DATE_1),P_NO_1))
=Sum({<P_NO_1=P({<STATUS_1={90}, YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}P_NO_1), YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}
Aggr(FirstSortedValue({<YEAR_STATUS_DATE_1={'<$(=Max(YEAR_STATUS_DATE_1)-1)'}>}UnitsForMetsai, -YEAR_STATUS_DATE_1),P_NO_1))
hello Sunny , A huge thank you, appreciate you here much !!
hi Gupta - thanks 4 your help !!