Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
can anyone help me please?
Thanks in advance.
What has this to do with Qlikview or Qlik Sense?
QlikView only.
Thanks for your response.
can we change the data structure or not ? in excel you provided
sure
do you mean like this ? a draft version attached
Thanks for your proactive effort. Appreciate it. If you notice the value has changed to 150%. Which is wrong. Any suggestion?
Did you get my point?
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?