Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
abc_18
Contributor

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

Re: Set analysis expression is not working

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies

Re: Set analysis expression is not working

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Sameer9585
Contributor II

Re: Set analysis expression is not working

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)