Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikView app development

I have the data in the attached XLS and i want to distribute the data based on. PPT attached. Can any one help me.I have pointed two rows in the PPT

Thanks in advance.

 

Challenge

Danger

Healthy

Trending

 

11 Replies
Anonymous
Not applicable
Author

yes ..you are right friend

johnca
Specialist
Specialist

Then it looks like Dave Lau had you pointed in the right direction. As he asked, you should also try to get the data file in a better format. Merged cells/rows are no fun.

For each chart dimension use Date(Date,'MMM-YYYY') to get the format you displayed a la "Mar-2017", et al.

Each chart should have 3 expressions:

     Min(Healthy)

     Avg(Healthy)

     Max(Healthy)

     Min(Challenge)

     Avg(Challenge)

     Max(Challenge)

     Min(Danger)

     Avg(Danger)

     Max(Danger)

     Min(Trending)

     Avg(Trending)

     Max(Trending)