Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - Combining 2 measures together that includes COUNT, DATE and String/Char

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. 

Labels (4)
1 Solution

Accepted Solutions
kaushiknsolanki

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'))

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

1 Reply
kaushiknsolanki

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'))

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post