Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a table with salary.i need to show top 10 salary in graph but there is no dimension limits . in qliksense
could u please tell me steps. one more doubt i need to show yearly treand but there is no option in qliksense i tried with combit o chart also.
** bar chart with line chart , like above bar line chart should come**,monthly bar and department wise line chart.
HI,
You can try Rank() and Aggr() for this
=Sum({<EmployeeID={"=Aggr(Rank(Sum(Salary)) <= 5, EmployeeID)"}>} Salary)
OR
=Aggr(If(Rank(Sum(Salary)) <= 5, Sum(Salary)), EmployeeID)
Hope this helps you.
Regards,
Jagan.
IN Limitations there is options top amd bottom
Try this expression for salary (and same set analysis for each expression if there are multiple):
sum({<EmployeeID={"=aggr(rank(sum(Salary))<=10,EmployeeID)"}>} Salary)
HI,
You can try Rank() and Aggr() for this
=Sum({<EmployeeID={"=Aggr(Rank(Sum(Salary)) <= 5, EmployeeID)"}>} Salary)
OR
=Aggr(If(Rank(Sum(Salary)) <= 5, Sum(Salary)), EmployeeID)
Hope this helps you.
Regards,
Jagan.
Hello abc / Satish, I have noticed you have posted many questions in the forums and that many have responded to you. When you get a chance can you also please update the ones where people have kindly responded to you as well as mark those correct or helpful so our team and community know that you have been helped.
You can see your activity by clicking on your name and then the activity tab:
Thanks for your help in improving how we can all work together in the Qlik Community.
Regards,
Mike T
Qlik
Thanks Qlik Community,Michael For Your Quick Response Regarding My Doubts.i updated all my post