Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

field value does not repeat for next seven(7) days

Hii,

I have field policy no and mobile no,I want that after daily refreshed same field value should not be repeat for next seven(7) days ??

so what is logic foe that ???

8 Replies
Anil_Babu_Samineni

Can you explain this part "field value should not repeat for 7 days"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
techvarun
Specialist II
Specialist II

for that first you need a date field. (Or refreshed date) and we need to pick the data loaded in last sevendays and the new data to pick and exclude the repeated data.

Share a sample data

dhavalvyas
Contributor III
Contributor III
Author

so how to apply logic for it ???

dhavalvyas
Contributor III
Contributor III
Author

can you tell with some example ???

techvarun
Specialist II
Specialist II

Do you have any sample data?

dhavalvyas
Contributor III
Contributor III
Author

Sorry boss,you can just tell roughly or roughly idea ???

techvarun
Specialist II
Specialist II

Without Sample data and expected result its not easy to define a logic.

dhavalvyas
Contributor III
Contributor III
Author

Ok, just tell me one logic that I store one of table into one folder which is automatically copy into other after daily reload ????