Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing of particular period

Hi All,

I have a qvd data in that the data as following.

Date

4/31/2011

5/30/2011

6/30/2011

7/31/2011

8/01/2011

8/02/2011

8/03/2011

........

........

8/30/2011

9/01/2011

9/02/2011

9/03/2011 etc

9/31/2011

I need the out put data in report level  like this only monthend data:

4/31/2011

5/30/2011

6/30/2011

7/30/2011

8/30/2011

9/31/2011

Plz find the attached sample data.

Thanks,

Ravi Teja

3 Replies
MayilVahanan

HI

Try like this

If(Num(Date) = Floor(MonthEnd(Date)), Date) As Date

or

Just use MonthEnd(Date) to convert the from date to MonthEnd date.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

hi

try to use distinct keyword, like below example.

in script--

load Distinct Date

from tablename;

******************************

in expression--

only(Distinct Date)

or try this

sum(Distinct Date)

Not applicable
Author

Thanks both...But when am using the monthend(date) it showing actual month end date(calender date) instead of date having date filed in qvd level.

Plz find the same

Thanks,

Ravi Teja.