Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Comparing values

Hi,

This is one of 4 benchmarks loaded from excel file and it is not linked to other tables.

BenchmarkMinValueMaxValueRate
Production100 10
Production9099,999
Production8089,998
Production7079,997
Production6069,996
Production5059,995
Production4049,994
Production3039,993
Production2029,992

 

Before devoloping app any further, I need some help with set analysis(?).

How to get the rate to straight table without using any selections?

This simple calculations works when using more dimensions but that is not the solution:

if(Sum(ProductionValue)/sum(Hours)>=MinValue and Sum(ProductionValue)/sum(Hours)<=MaxValue, Rate)

 

WeekSum(ProductionValue)/sum(Hours)Rate
3317,75-
3490,70-
1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Thanks! I haven't seen that link before about set analysis.

 

Anyway, FirstSortedValue with if, did the trick and app is working.

View solution in original post

4 Replies
Highlighted
Contributor II
Contributor II

Anyone?

Highlighted
Contributor II
Contributor II

Some progress...

I got rate 9 for week 34 by using FirstSortedValue. Still have to find out how to get the rate if value is below range.

 

FirstSortedValue(Rate,
aggr(if(Sum(ProductionValue)/sum(Hours)>=MinValue,-MinValue),Week,Rate))

Highlighted
Digital Support
Digital Support

Here is a Design Blog link that may help you further with things:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are some additional/related links at the bottom of that post, just FYI.  

Here is Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

This will kick things again, someone else may have some further guidance as well.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Contributor II
Contributor II

Thanks! I haven't seen that link before about set analysis.

 

Anyway, FirstSortedValue with if, did the trick and app is working.

View solution in original post