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: 
RogerG
Creator
Creator

Peek with order in another column

Hello all,

 

I am trying to get the peek of a date but only where the sort order of the activity is not null

ActivityTable:
Activity, Start, Finish
PG_DISC, 1/1/2021, 1/1/2022
A1,1/1/2022,2/2/2022
PG_1, 1/1/2022, 2/2/2022
A2, 2/2/2022,3/3/2022
Another Activity 3/3/2022,5/1/2022
PG_2, 2/2/2022, 3/3/2022
PG_Sub, 3/3/2022, 5/22/2022

SortOrderTable
load *
inline [
Activty, ActivitySort
PG_DISC,1
PG_1,2
PG_2,3
PG_SUB,4

 

I tried Peek, and understand I could create a table with just the values I need, but wonder if there is a better way.

 

Thank in Advance.....

Labels (2)
1 Reply
smith11484
Contributor II
Contributor II

Thanks for the information, keep sharing this type of info  NGS Medicare