Qlik Community

App Development

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qs123
Contributor II
Contributor II

count of dimensional value with if condition against expression measure

Hi,

Within the License Monitoring App, I have created a table with one dimension and one measure.

  • Dimension  = User Name
  • Measure = If user has never logged in, then count number of days since the License was allocated and today's date... Else count the number of days since the User was last logged and Today's date

 

The expression I use is as this...  if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

 

The above expression is giving me expected result in the table. But I want to use a single value in KPI to show total number users who have been inactive since more then 90 days..

 

so.. how do I count total number of users, which has this measure value > 90 ?

 

 

Labels (4)
1 Reply
forte
Partner - Creator
Partner - Creator

Hi @qs123 

Just try this, using aggr

sum(

aggr(

if(

if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

> 90,1,0)

, [User Name]

)

)

Hope it helps

Regards