Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Removing of particular period

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.

Highlighted
Not applicable

Re: Removing of particular period

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)

Highlighted
Not applicable

Re: Re: Removing of particular period

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.