Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)
0 Replies