Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to figure out a way to rank the top 5 values of the latest calendar week and show the past 3 calender weeks of that value as well.
I've got some sample values in an excel sheet attached to this.
I've got this expression to calculate the top 5 per week:
=IF(Woche = MAX(Woche),IF(RANK(SUM(AGGR(SUM(Kosten),Überarbeitet,Kalenderwoche))) <= 5,SUM(AGGR(SUM(Kosten),Überarbeitet,Kalenderwoche))))
Though of course when I put it in a line chart with week as a dimension, it will calculate the top 5 for that respective week.
What I need is to find the top 5 error causes from the latest week and keep those top 5 errors and show their historic data for the past few weeks.
Thank you for your assistence 
Unfortunately no, I didn't got a solution. The request lost it's interest
so I didn't pursue it further.
However, if you got a solution or find one, it would be really kind to let
me know
Von: john cena <qcwebmaster@qlikview.com>
An: Marius Berthold <marius.berthold_external@de.kspg.com>,
Datum: 29.10.2016 18:45
Betreff: Qlik Community: New reply - Show history of a Top 5 value
You've received a new response to your question: Show history of a Top 5
value
Please take a minute to log in to Qlik Community, review the responses,
and mark any Helpful or Correct answers.
You can mark up to two helpful answers and one correct answer. This
rewards other members for taking the time to assist you.
Best Regards,
Qlik Community Management
Comment by replying to this email, or go to the question on Qlik Community
No longer wish to receive these emails? Go to your email preferences and
turn off the setting for "Social activity directed at you, such as
@mentions, shares, and messages".
© 1993-2016 QlikTech International AB | Copyright & Trademarks | Privacy |
Terms of Use | Software EULA