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: 
Kumar6
Contributor
Contributor

How to fetch a get a data for this scenario

Hello all,

I am facing problem in deriving the solution for below problem

Load 

dt_diff, sequence

5  , 1

45, 2

90, 3

180, 4

270, 5

I wanted a solution like this  below

dt_diff, sequence

5  , 0

45, 1

90, 2

180, 3

270, 4

Anything  less than dt_diff  45 should come under the sequence 0, then it should populate sequentially

hope my question is clear

any inputs appreciated

 

 

Labels (3)
1 Reply
Taoufiq_Zarra

@Kumar6  just to understand what is the expected output from this :

dt_diff, sequence

5 , 1

45, 2

90, 3

4,4

180, 5

270, 6

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉