Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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)