topic Re: Grouping selection. in QlikView

Grouping selection.

sibusiso90 — Mon, 13 Nov 2017 13:42:05 GMT

Hi all,

Please assist, I am trying to make a selection that selects all the groups where the selected is at.
E.G below

From above, when I select sale1 I want to see group2, group3 and group5 with all the information.

The output should be as follows.

stalwar1‌ tresesco‌

Re: Grouping selection.

sunny_talwar — Mon, 13 Nov 2017 13:48:12 GMT

Are you making the selection in the chart itself?

Re: Grouping selection.

sibusiso90 — Mon, 13 Nov 2017 13:51:00 GMT

No, we will have a list box that they select from.

Re: Grouping selection.

sibusiso90 — Mon, 13 Nov 2017 13:54:15 GMT

This what I am working from.

Re: Grouping selection.

sunny_talwar — Mon, 13 Nov 2017 13:57:37 GMT

May be this

=Sum({<Sale, Group = {"=Sum(Value) > 0"}>}Value)

Re: Grouping selection.

sibusiso90 — Mon, 13 Nov 2017 14:12:50 GMT

stalwar1‌

Thanks you have been very helpful.

Re: Grouping selection.

sibusiso90 — Tue, 14 Nov 2017 10:31:12 GMT

Hi all,

I was assisted yesterday with group selections but now I am stuck on how to apply it on my model as I use valuelist instead of a field as a dimension and I can't use cross table as it is a huge table with over 100 columns and about 1m rows which as growing daily.

Attached is a model identical to my situation

stalwar1‌

tresesco‌

Thanks