topic Re: Chart with selected Name and Total in QlikView

Chart with selected Name and Total

Anonymous — Mon, 10 Feb 2014 21:05:25 GMT

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

Re: Chart with selected Name and Total

Anonymous — Mon, 10 Feb 2014 21:30:37 GMT

any ideas?

Re: Re: Chart with selected Name and Total

Anonymous — Mon, 10 Feb 2014 21:47:00 GMT

A sort of - see attached.

Re: Re: Chart with selected Name and Total

Mon, 10 Feb 2014 22:09:45 GMT

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

Re: Chart with selected Name and Total

Anonymous — Tue, 11 Feb 2014 16:51:51 GMT

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,

Re: Chart with selected Name and Total

Anonymous — Tue, 11 Feb 2014 16:56:12 GMT

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,

Re: Chart with selected Name and Total

Tue, 11 Feb 2014 18:21:57 GMT

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

Re: Re: Chart with selected Name and Total

Anonymous — Tue, 11 Feb 2014 19:01:45 GMT

I updated the file.

The problem, when you select Name automatically selected POV.

Re: Chart with selected Name and Total

Anonymous — Tue, 11 Feb 2014 20:43:00 GMT

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