topic Re: Append values from different groups in QlikView

Append values from different groups

maxsheva — Thu, 25 Apr 2019 19:14:19 GMT

Hi,

Let's assume one field with values associated with different groups.

Field, Group

Field1, Group1

Field2, Group1

Field3, Group2

Field4, Group2

I need to present Field and Group as separates ListBoxs .

Is there possible way to append values from different groups on selection?

e.g.

1st step: Select Group1

2st step: Select Field1

3rd step: Select Group2

4rd step: Select Field4

As result I need to get both Field1 and Field4 values in a Field

Any help would be much appreciated!

pedromsouza — Thu, 25 Apr 2019 18:24:45 GMT

In "3rd step" you meant "Group2"?

You could select Groups 1 and 2 using control keyboard then select field 1 and 4.

Qrishna — Thu, 25 Apr 2019 18:44:43 GMT

Can you post your expected result? The logic you have is a bit confusing.

maxsheva — Thu, 25 Apr 2019 19:16:30 GMT

Yes, correct should be Group2 in a step2.

I have changed it in my initial post.

The requirement is to present values from Field separately per each group therefore I need to select one by one as mentioned earlier.

maxsheva — Thu, 25 Apr 2019 19:33:58 GMT

Hi,

You may find example of expected result below

"As result I need to get both Field1 and Field4 values in a Field"

Listbox doesn't allow to append values from one field if it is separated by different groups.

Groups should be selected separately.