Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Create multiple lines from a table

Hi all,

I want to create a table with the (creating a unique code that identifies the customer&month)customers  that buys a freepass. I created a table from the initial order that "starts" the freepass period (90 days)

This is the table:

created_atCustaccountQuarterly_DPASSSalesBOidQUARTELY_DPASS_ID
02/01/2017C00003921134283PV00405616C000039-2017-1
02/01/2017C00271121134283PV00405617C002711-2017-1
02/01/2017C05280521134283PV00405618C052805-2017-1
02/01/2017C06370121134283PV00405621C063701-2017-1

ant the result has to 3 lines per each line. Each one for present created_at code, +30 days created_at, +60days created_at

2017-03-07_16h36_12.png

thank you very much for your help

Eduard

0 Replies