Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator III

How to select last previos occurrence population Depending on selected year ?

hello to all the Outstanding minds ,

i need to make a selection from all the population in my model : by choosing a year i need to select for each project (p_no_1)  the last occurrence that is previos to the selected year .  for example , if we chose year 2015 - then we Expect to see only th chosen population that marked in yellow :

selectYear_PrevPopulation.PNG

the selected year in the listbox dont have to be YEAR_STATUS_DATE_1 , any possible solution (even macros) wil be aprishiated ,

help .... thanks !

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

have a look at the attach example

by click the button it make the selection of the relevant records

this assuming we can select the record id

View solution in original post

9 Replies
MayilVahanan

Hi

Please post a sample application

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Gysbert_Wassenaar

Can you post a small qlikview document that illustrates the problem?


talk is cheap, supply exceeds demand
lironbaram
Partner - Master III
Partner - Master III

hi

have a look at the attach example

it uses the first sorted value

yanivvl0
Creator III
Creator III
Author

Here guys .

yanivvl0
Creator III
Creator III
Author

shalom Liron , it is a good start , but i need more , the next action after select a year is to select all the requested  population  that i mentioned above , is it possible ?

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
yanivvl0
Creator III
Creator III
Author

Hi Gysbert , thanks agian !! , as i replay to Liron , the next action after select a year is to select all therequested  population  that i mentioned above , so , if we use your waderfull solution , we say that we need to select all the members from the P_NO_1 and YEAR_STATUS_DATE_1 columns in the table "YEAR_STATUS_DATE_1".

( the first selection of year can be removed  )  , many  thanks .

lironbaram
Partner - Master III
Partner - Master III

have a look at the attach example

by click the button it make the selection of the relevant records

this assuming we can select the record id

yanivvl0
Creator III
Creator III
Author

Hi Liron - it is a great help for us - THANKS !!!