Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

KPI - minimum from value

Hello, I made in Qlik sense app, where I have a bar chart. On X axis I have date. On Y axis I have set analyse: count({$<[Storage Type]={'FGB'}>}[Empty indicator])/3. And it work. /3 is because i have as base each day 3 values and I need avarage from it.

But now I have problem. I need make KPI, where I see lowest value from all for selected date. And I dont know how. I tried something like: min (aggr (count({$<[Storage Type]={'FGB'}>}[Empty indicator]))) - system write me:error in expresion.

Please, can somebody give me a advice, how shall make it? Thank you

2 Replies
aarkay29
Specialist
Specialist

may be this:

min (aggr (count({$<[Storage Type]={'FGB'}>}[Empty indicator]),Date))

Anonymous
Not applicable
Author

Its work, but isnt it what I wanted. I get daily three files. And min (aggr (count({$<[Storage Type]={'FGB'}>}[Empty indicator]),Date)) give me lowest daily sum for choosed days. I need lowest daily value.

Example:
I have 1.1.2017 - 10, 5, 20  (first value, second, third)
           2.1.2017 - 3, 14, 12

           3.1.2017 - 22, 44, 8

And I get as result now 29 (lowest sum 3, 14, 12)

But I need get as result 3 (lowest value from all)