Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ravikumar_iyana
Creator
Creator

Top5 using Set analysis with rank() in Line Chart

Hi Community,

I'm facing an one issue in evaluate expression.

I'm providing sample data please check below:

workload:

Log HourWDNAMEDelay_time_min
0WD-BATCH30.73
1WD-Stats30.62
5WD-BATCH-NoUtil-AllAmp29.50
6WD-BATCH-NoUtil-AllAmp29.42
7WD-RPT-Short-Tblu29.26
8WD-BATCH-High-NoUtil-AllAmp26.93
9WD-Stats26.64
15WD-Stats45.63
16WD-BATCH-NoUtil-AllAmp22.67
20WD-BATCH-NoUtil-AllAmp43.89
23WD-RPT-Short-FDW24.66

 

Required line chart:

I'm taking: 

Dimensions 1.Log Hour

                         2. WDNAME(Top 5)

trying expression like this =Sum({<workload= {'Rank(Sum(DelayTime_Mins),4) <= 5'}>} DelayTime_Mins)

note: table name: workload

Measure: Delay_time_min

Top5.PNG

Labels (1)
1 Solution

Accepted Solutions
ravikumar_iyana
Creator
Creator
Author

Hi All,

Thanks for your suggestion.

I tried like this expression in 2nd dimension level "=IF(Aggr(Rank(SUM(DelayTime_Mins),4),WDName)<=5,WDName)" 

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

what about this?:

Sum({<Delay_time_min= {"=Rank(Sum(Delay_time_min),4) <= 5"}>} Delay_time_min)
ravikumar_iyana
Creator
Creator
Author

Hi All,

Thanks for your suggestion.

I tried like this expression in 2nd dimension level "=IF(Aggr(Rank(SUM(DelayTime_Mins),4),WDName)<=5,WDName)"