Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (4)
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