Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator
Creator

can anyone help me please?

Thanks in advance.

Highlighted

What has this to do with Qlikview or Qlik Sense?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator
Creator

QlikView only.

Thanks for your response.

Highlighted
Creator III
Creator III

can we change the data structure or not ?  in excel you provided

Highlighted
Creator
Creator

sure

Highlighted
Creator III
Creator III

do you mean like this ? a draft version attached

Highlighted
Creator
Creator

Thanks for your proactive effort. Appreciate it. If you notice the value has changed to 150%. Which is wrong. Any suggestion?

Capture.PNG

Highlighted
Creator
Creator

Did you get my point?

Highlighted
Specialist
Specialist

Your .pptx indicates you are looking for Min, Avg and Max values by Month. If so, simply change the Sum(Healthy) to Min(Healthy), Avg(Healthy) and Max(Healthy). (do the same for Challenge, Danger and Trending)

Else, what is it you are trying to do?