Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[HELP] can not count "max value"

hello..

i have a case that i have to count how much every dimension has the max value more then 0

dimension is "cd_name"

expression is max(value) to know how much is the maximum value

and to calculate max value more then 0 for every "cd_name" i use expression below :

if(count(max(value))>0,count(max(value))

)

but it shows no data

i try to change the expression to count(max(value))

and it shows no data neither

what's wrong with me?

and how to calculate it?

thx..

i really appreciate ur help

1 Reply
Miguel_Angel_Baeyens

Hello Richardo,

I don't know if this is what you want, but I'd try

Count({< value = {'$(=Max(value))'} >} cd_name)


Hope that helps