Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense- Getting daily running count measure

Hi Qlikers,

I am having a challenge replicating Power BI (DAX) measure to Qlik sense Measure and I am having an issue,

The DAX measure I am trying to replicate:

ABN FY20 Daily Incidents = (CALCULATE('ABN Incidents Combined'[IncCountABN], 'FiscalMnthTable'[FY] = "FY20"))/DATEDIFF("01-Oct-2019", TODAY(), DAY)

The Qlik Sense measures i got so far:

1. Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00') 
2. Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')

How I got the above:

DAX- IncCountABN = COUNTA([Incident Number])+0
Qlik -Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')

Then

DAX- ABN FY20 Incidents = (CALCULATE('ABN Incidents Combined'[IncCountABN], 'FiscalMnthTable'[FY] = "FY20"))

Qlik - 1.   Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00')


            2.  Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')

 

What I am trying to achieve is to combine the above measures (Qlik 1 &2)  and  get daily number which so far seems very challenging. Anyone who has DAX and Qlik would be awesome . Thanks in advance 

 

 

 

Labels (4)
1 Reply
YG
Contributor III
Contributor III
Author

I think I got it:

(Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))/
(Num(Count({<FYear_Num={$(=Max(FYear_Num)-1)}>} Incident_Number)/1, '##.00')/365)