Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

Set analysis expression is not working

Hi,

To calculate a KPI in my dashboard, I am using below expression:-

count({$<[End Date]={">$(vDynamic)"} and [ created date]={"<$(vDynamic)"},[Population tag]*={' Extended Warranty','Service Contract'},
[ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''},[contract]={' Contract'}>}Business)

But it's  just giving me '-' blank value, can someone please tell me where I am doing wrong

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?

count({$<[End Date]={">$(vDynamic)"}, and [ created date]={"<$(vDynamic)"}, [Population tag]*={' Extended Warranty','Service Contract'}, [ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''}, [contract]={' Contract'}>}Business)

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

View solution in original post

2 Replies
Anil_Babu_Samineni

Perhaps this?

count({$<[End Date]={">$(vDynamic)"}, and [ created date]={"<$(vDynamic)"}, [Population tag]*={' Extended Warranty','Service Contract'}, [ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''}, [contract]={' Contract'}>}Business)

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
Sameer9585
Creator II
Creator II

try this?

 

count({$<[End Date]={">$(=$(vDynamic))"} +[ created date]={"<$(=$(vDynamic))"},[Population tag]*={' Extended Warranty','Service Contract'},
[ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''},[contract]={' Contract'}>}Business)