Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I WROTE EXPRESSION LIKE THIS RANK(SUM(SALARY),2) IN EXPRESSION TAB . BUT IT DISPLAYED 2ND
IT DISPLAY SECOND HIGHEST ID BUT I WANT TO DISPLAY 2ND HIGHEST SALARY.PLS SOLVE THIS PROBLEM .HOW TO DISPLAY SECOND HIGHEST SALARY .
REGARDS
MADHU
Sum(Max(Salary,2))
HI RAKESH KUMAR,I WROTE EXPRESSION LIKE THIS SUM(MAX(SALARY,2))BUT IT DISPLAY MAX SALARY ID NUIMBER IT DOES NOT DISPALY 2ND HIGHEST SALARY.I WANT TO DISPLAY 2ND HIGHEST SALARY PLS
TELL ME OUT HOW TO DISPLAY 2ND SALARY IN QLIKVIEW.
Hi Madhu,
Sorry I didn't understood your question?
If you just want the second highest salary , you can create a text box with this expression: Max(Salary,2)
I dont understand what you are trying to show inside the Straight table? Can you post a example output on what you are expecting, ex. fill an excel table , take a screenshot and post it so I can understand?
Hi Madhu,
like this
Regards,
Antonio
=Aggr(If(Sum(SALARY)>=Max(TOTAL Aggr(Sum(SALARY), Name), 4), Name), Name)
Also, if you don't need the total this expression can work avoiding calculated dimension:
If(Sum(Sales)>=Max(TOTAL Aggr(Sum(Name), Name), 4), Sum(Name))
HELLO RAKESH KUMAR.I WANT TO DISPALY 2ND HIGHEST SALARY IN STRAIGHT TABLE.LIKE THIS
THIS IS MY STRAIGHT TABLE DATA.
ID NAME SALARY
1 MADHU 15000
2 KALYAN 20000
3 MANJU 23000
4 RAM 8000
5 SREEKAR 13000
I WROTE EXPRESSION IN EXPRESSION TAB LIKE THIS RANK(MAX(SALARY),2).BUT I DISPLAY ABOVE TABLE ID LIKE THIS 1 BUT I WANT TO DISPLAY 2ND HIGHEST SALARY LIKE THIS 20000.PLS TELL ME OUT HOW TO DISPLAY LIKE THIS
ID NAME SALARY
2 KALYAN 20000
Your need ?
Hi,
one solution could be:
hope this helps
regards
Marco
You need to write Calculated dimension as
if(aggr(rank(sum(SALARY)),ID)=2,ID)
& Expression as Sum(SALARY)
Also Suppress the Null values of this Calculated Dimension. Hope This Helps
Regards
Abhishek