Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count last month from every week start

hi all,

i want to count the projects whose status are "open"

but i want to count only for month back from every week start

for example 12.11.2012 is my week start so iwant to count all "open" projects until 12.10.2012

then the same process for 05.11.2012

and the same process for all weeks

thanks a lot

3 Replies
Not applicable
Author

Hi,

This is the condition where you can select a date and based on your selection it will look from the last month and before values and it will provide the report.

If you are specific to open projects, then add the status in you set analysis as open.

Count({<Date={"<=$(=AddMonths(Date,-1))"}>} Date)

Thanks,

Srini.

Not applicable
Author

thanks Srini

but there wont be any selection

on a  bar chart i will show every week start

Not applicable
Author

Ok, then add Max on top of the week start date and add the addmonths function.

=AddMonths(Max(WeekStart(Date)),-1)

Thanks,

Srini.