topic percent ++ in QlikView

percent ++

Anonymous — Fri, 02 Dec 2011 21:45:22 GMT

Hello,

New to QVlets say I have this table:

name	choice	date
dan	a	12/1/2011
peggy	a	12/1/2011
dan	b	12/2/2011
ben	C	12/3/2011
dan	b	12/3/2011

I need to present the percent of number of times a certain person chose a certain decision form all his decision. For example dan chose option B (twice ) and dan made 3 decision in total meaning dan chose B 66.67% times.

how can I present this with a chart showing dan with 66.67% ( while choosing dan & choosing B in the list boxes)?

Thanks for the help

Re: percent ++

johnw — Fri, 02 Dec 2011 21:49:35 GMT

Maybe this?

count(choice)/count({<choice=>} choice)

percent ++

Anonymous — Fri, 02 Dec 2011 22:00:18 GMT

thanks it work could u explain this part count({<choice=>} choice) ??

percent ++

johnw — Fri, 02 Dec 2011 22:09:20 GMT

That count is using set analysis. The {<choice=>} part is where the set is defined. What it says is basically "ignore any selections in choice". So that count says "count the number of choice records while ignoring any selections in choice". So it's the count of all of that person's choices, ALL the decisions that Dan made, even though you selected choice B.

If you're new to set analysis, you can find more about it in the help file index, or in the reference manual.

percent ++

Anonymous — Fri, 02 Dec 2011 22:20:45 GMT

Thanks alot John

Re: percent ++

IAMDV — Sat, 03 Dec 2011 20:09:04 GMT

Hi John,

Can we use the Total qualifer? Something like this...

count(choice)/count(Total choice)

Thanks,

Re: percent ++

johnw — Mon, 05 Dec 2011 19:51:31 GMT

We could indeed use count(choice)/count(total <name> choice) if no dimensions were selected. But in this case, we are "choosing B in the list boxes", so ignoring the choice dimension isn't sufficient. We have to ignore the choice selection, which suggests using set analysis.