topic Re: set analysis on selection in QlikView

set analysis on selection

doespirito — Mon, 16 Oct 2017 08:48:28 GMT

Hello,

I try to create a selection field with set analysis.

in this example (see qw attached), the graph shows sales from junuary to the selected month with set analyssis..

We can see dupont and durand in the graph.

But in the selection field member, we only see durand.

Can i have dupond and durand in the selection field?

And how can i do that ?

Thank you very much for your help,

Arnault

Re: set analysis on selection

effinty2112 — Mon, 16 Oct 2017 10:07:40 GMT

Hi,

In the member listbox dupont is in grey for a very good reason. You have selected year = 2017 and month = 8 and dupont is not associated with these selections and so is grey. You can still select dupont when it's grey but you will lose your selection month = 8.

Regards

Andrew

Re: set analysis on selection

doespirito — Mon, 16 Oct 2017 10:59:36 GMT

Thank you for your response,

i know why dupont is grey but i would like to create a selection box with all people who have made sales from january to selected month.

and not only in august, as in the chart.

Re: set analysis on selection

sunny_talwar — Mon, 16 Oct 2017 12:26:13 GMT

May be use The As-Of Table

Re: set analysis on selection

doespirito — Mon, 16 Oct 2017 12:53:00 GMT

wonderfull !!

exactly what i wanded