Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
joeybird
Contributor III

Count current month

Hiya

in my sql data load I have Order_Date in the following format

20140101 00:00:00

this contains data for 3 years.

I have in my data load done this

Month(Order_Date) as Month

my expression is

count({$< Month ={$(=Month(today()))}  >}Customer_ID)

but it is counting every order date month that contains October, I just want count for Oct 2015

if I do this

count({$< Month ={$(=MonthStart(today()))}  >}Customer_ID)

I get -

Please Help

1 Solution

Accepted Solutions

Re: Count current month

Try this may be:

Date(Order_Date) as Order_Date

Expression:

=Count({<Order_Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} Customer_ID)

View solution in original post

3 Replies

Re: Count current month

Try this may be:

Date(Order_Date) as Order_Date

Expression:

=Count({<Order_Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} Customer_ID)

View solution in original post

joeybird
Contributor III

Re: Count current month

Awsome

thank you Sunny x

Kind Regards

ZoeM
Contributor III

Re: Count current month

Hey Sunny,

I have a similar issue. My expression is:

=Date(Today(),'MMM')& ', '& Count({$<[Date Type]={'VPP Dates'},YearMonth={$(=Date(Today(),'MMM'))} >}Gateways)

Expression is OK, but my result is zero.

I am trying to specify a data point for total sales for current month (November in this case).