Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad333
Contributor III
Contributor III

Getting period of data

Hi all,

So here the scenario is, I have to get the dates for 24 months of period for a sales report and it should be automated. Suppose I should a time period from 1/4/2017 to 1/4/2018 but when it comes to the 25th month, the start date of 1st month should also be changed, so that I would get results for only 24 months.

Should I go for YTD or anything else?

And it should be in the scripting, not in front end.

Thanks

KHARANSU

25 Replies
prasad333
Contributor III
Contributor III
Author

Hi Youssef,

First of all I'm very sorry for the misleading information but thank you very for the understanding and giving out the solution. It's working now.

Thank you.

YoussefBelloum
Champion
Champion

no problem at all.

don't forget to close the thread my marking the correct and the helpful answers.

Good luck

prasad333
Contributor III
Contributor III
Author

sorry youssef, but I'm not getting that option.

YoussefBelloum
Champion
Champion

of course you can,

CorrectAnswer.PNG

I'm sure you can see the Green star on this thread under each comment (this is for correct answer)

for helpful answers, you should click on Actions.

prasad333
Contributor III
Contributor III
Author

No Youssef, If I had that option I wouldn't have requested you.

YoussefBelloum
Champion
Champion

No Problem, I thought you haven't see it..

mto‌ I don't know who is the right person to look at this, but prasad333 have issues closing his threads.. maybe you know some administrators that can take a look at this ?