Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Oguzhan
Contributor III
Contributor III

QlikSense Count when Date is in Month with base date

Hello,

I am trying to do the following calculation.

I have a MasterCalender starting from field name 'datum'= 01.01.2000 - today()+10 years this is my dimension  date(datum,'MMM.YY')

Oguzhan_0-1608718866138.png

My Table data

TaskStatus20Status50
880012310.12.202022.12.2020
880012409.10.202019.11.2020
880012409.10.202019.11.2020
880012517.11.202020.11.2020
880012517.11.202020.11.2020

 

I want to show how many Tasks (distinct) were in each month in Status 20 and Status50. Similiar to this

Oguzhan_1-1608719051482.png

 

So far I have no clue how to include the Status20 or Status50 in my expression.

Thank you in advance

Labels (1)
3 Replies
Anil_Babu_Samineni

PFA

2020-12-23 11_39_19-Qlik Sense Master.png

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Oguzhan
Contributor III
Contributor III
Author

I tried it in a similar way but it gives me always the same amount in each month whether for Status20 or Status50

Anil_Babu_Samineni

Have you restricted Flag based on measure?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful