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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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
MVP
MVP

@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") 😉