Qlik Community

Qlik Sense App Development

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

joeybird
Contributor II

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
MVP
MVP

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)

2 Replies
MVP
MVP

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)

joeybird
Contributor II

Re: Count current month

Awsome

thank you Sunny x

Kind Regards