Dashboard Question

[zwyne]

Hello Experts,

I have requirement to create dashboard in QlikView based on the following logic:

I have attached sample data, Expected dashboard in QlikView (something similar) and scores dashboard. So in the sample data the columns of interest are:

• Issue Priority and filtered
  • Major
  • Limited
• Issue Status
  • On track
  • Pipeline
  • Awaiting validation
• Due by Category
  • within 30 days

So (This is based on Scores dashboard)

• I want to calculate the Total Major issues score for On track and Pipeline (within 30 days)
  • <10%  major issues then score=7 or if 10-20% then score =10 or if >21% major issues then score =14
• Similarly for the Total limited issues score for On track and pipeline( within 30 days)
  • if>90% Limited issues then score =5 or 80-89% limited issues then score =8 or if <79% then score =12
• For Total issues AIV( Awaiting validation)
  • >70% of issues AIV then score = 2 if 20-69% issues AIV then score = 3 of if < 20% then score =5

My requirement is to produce  the Expected Dashboard in QlikView.

Your assistance will be highly appreciated.

Thanks

[Michiel_QV_Fan]

And your question is?