Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yanivvl0
Contributor III

How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

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.

Tags (2)
1 Solution

Accepted Solutions

Re: How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

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


Capture.PNG

View solution in original post

4 Replies

Re: How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

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


Capture.PNG

View solution in original post

vsudhakar
Contributor III

Re: How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

=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))

yanivvl0
Contributor III

Re: How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

hello Sunny , A huge thank you, appreciate you here much !!

yanivvl0
Contributor III

Re: How to sum the last value for all the members - prev prev the selected year (with filter) prev prev ?

hi Gupta - thanks 4 your help !!