HELP Count ifs

[bhaddour]

Hi everyone, 

I've been struggling with this for a while. I'm new in Qlik sense !

I have a table and this is the header ( data loaded ) 

Customer type could be : FR or WH

Creation date(SAP) format : September 1, 2017

and I want total of FR customers created previous month and current month, and same thing for WH. 

It should be easy I don't know why it's not working... 

Please help

[Kashyap_R]

Hi

Try this

Current Month  

Count({$<Creation date={">=$(=Monthstart(max(Creation date)))<=$(=Monthend(max(Creation date)))"},

[Customer type]={'FR'}>}[Customers])

Previous Month

Count({$<Creation date={">=$(=Monthstart(AddMonths(max(Creation date),-1)))<=$(=Monthend(AddMonths(max(Creation date),-1)))"},[Customer type]={'FR'}>}[Customers])

Hope this helps

Thanks

[bhaddour]

Hi, 

It doesn't work ..

[dwforest]

You have to replace Creation date in @Kashyap_R's answer with the date from your dataset, include [ ] or "" if spaces

[Kashyap_R]

Hi

Share a sample QVF, I will try and get you back.

Thanks