Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
EsmeeM
Contributor II
Contributor II

Count if

Hi all,

I'm trying to return a count of the systems that perform under norm of the last month's data. I have a table with SystemIDs, Dates and availability values.

So far I have tried the following syntax with no good results:

=Count({<Availability = {"<=0.99"}, $(vSetMTD) >} SystemID)

(Result is 0)

It also does not work without the last month $(vSetMTD) restriction. 

Can anyone tell me what I am doing wrong here?

Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
EsmeeM
Contributor II
Contributor II
Author

I've got it now, sorry

 

=Count({<Availability= {"=Avg({< $(vSetMTD)>} Availability) < System_Norm "}>} SystemID)

View solution in original post

1 Reply
EsmeeM
Contributor II
Contributor II
Author

I've got it now, sorry

 

=Count({<Availability= {"=Avg({< $(vSetMTD)>} Availability) < System_Norm "}>} SystemID)

View solution in original post