topic Re: How to create this graph on qlikview in QlikView

How to create this graph on qlikview

Tue, 28 Aug 2012 07:21:39 GMT

I have the table of surveys as followed

Count Overall Experience Recommend Visit

--------- --------------------------- --------------------- -----------

1 Extremely Satisfied Yes Yes

1 Dissatisfied No No

1 Satisfied Yes Yes

1 Extremely Satisfied No No

1 Satisfied Yes Yes

1 Dissatisfied No No

I want to create a graph similar the one attached.

Note in the graph for overall Satisfaction % = Extremely Satisfied Count + Satisfied Count / all count

Recommend % = Yes Count / all count

Visit % = Yes Count / all count

Re: How to create this graph on qlikview

Tue, 28 Aug 2012 10:45:31 GMT

you can do it many ways

try to do it by making an island and creating an if/set analysis expression

check this qvw

Re: How to create this graph on qlikview

Tue, 28 Aug 2012 10:59:17 GMT

Sorry cannot open the file

Re: How to create this graph on qlikview

jagannalla — Tue, 28 Aug 2012 11:13:47 GMT

Hello,

In edit script use below script:

data:

LOAD * INLINE [

Count , Overall Experience, Recommend, Visit

1, Extremely Satisfied, Yes, Yes

1, Dissatisfied, No, Yes

1, Satisfied, Yes, No

1, Extremely Satisfied, No, No

1, Satisfied, Yes, No

1, Dissatisfied, No, No

];

island:

LOAD * INLINE [

dimension

Would You visit this hospitak again?

Would You recomend this hospital?

Overall Experience

];

- Now take ST table with Dimension as dimension and in expression add expression as

=if(dimension='Would You recomend this hospital?',

sum({$<Recommend={"Yes"}>}Count)/sum(Count),

if(dimension='Would You visit this hospitak again?',

sum({$<Visit={Yes}>}Count)/sum(Count),

if(dimension='Overall Experience',

sum({$<[Overall Experience]={'Satisfied','Extremely Satisfied'}, Visit={Yes}>}Count)/sum(Count))))

This is the script given by Pari Pari. Perfect solution for you.