Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I am trying to Combine 2 measures together and i am finding it challenging .
1. (Num(Count({<FYear_Num={$(=Max(FYear_Num))}>,} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))
2. Count( {<[Priority]={'1 - Critical','2 - High'}>} Incident_Number)
I want both of these combined together as one measure.
So far I have tried,
1. (Num(Count({<FYear_Num={$(=Max(FYear_Num))}> && <[Priority]={'1 - Critical','2 - High'}>,} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))
2. (Num(Count({<FYear_Num={$(=Max(FYear_Num))}> , <[Priority]={'1 - Critical','2 - High'}>,} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))
3. (Num(Count({<FYear_Num={$(=Max(FYear_Num))}>,}&&{<[Priority]={'1 - Critical','2 - High'}>} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))
Nothing seems to be working so far. Any help would be appreciated.
Hi, Try this.
(Num(Count({<FYear_Num={$(=Max(FYear_Num))}> +<[Priority]={'1 - Critical','2 - High'}>} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))
Hi, Try this.
(Num(Count({<FYear_Num={$(=Max(FYear_Num))}> +<[Priority]={'1 - Critical','2 - High'}>} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))