Chart with selected Name and Total

[Anonymous]

Hi friends,

I don't know how to make stacked chart with selected variable and Total?

I have list box, where I select "name" from variable Name and compare to Overall (Total)

Please find my QV file.

Thanks

[Anonymous]

any ideas?

[Anonymous]

A sort of - see attached.

[#4]

Something like this? Wouldn't work with a large number of names though.

[Anonymous]

Hi Rebecca,

Thanks for your helping.

It works well, but when Name doesn't have answers for 1 tag of POV, the Overall bar doesn't show all tags. (it not consist 100%) .

Do you know how to fix it?

Or you need sample QV file?

Thanks,

[Anonymous]

Thanks Michael,

Rebecca suggested better way.

In your sample I can't use legend and Name doesn't show "actual name"

Her sample doesn't show all tags for Overall, if Name doesn't have all tags.

Could you help with it?

Thanks again,

[#7]

Hmm. That's weird. I would have thought the set analysis would have avoided that. I will play with it.

[Anonymous]

I updated the file.

The problem, when you select Name  automatically selected POV.

[Anonymous · Accepted solution]

I got it. Thank you, guys.

I used msolomov structure and combined with Rebecca idea

if(ValueList($(vValueList))='A',

count({<[POV]={'*myself*'}>}respondentID)/count({<[ POV]=>} respondentID),

if(ValueList($(vValueList))='B',

count({<[POV]={'*myself*'}>}respondentID)/count({<[POV]=>} respondentID),

count({1<[POV]={'*myself*'}>}respondentID)/count({1} respondentID))))

and so on for each POV