Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Get all field values

Hi,

I need to concatenate all field values inside a straight table, disregarding the selections made in this field.

Example:

Category     ProductNr

-------------     ---------------

A               1

A               2

B               1

B               4

C               1

C               5

C               6

D               7

D               8

A selection is made in field ProductNr, Value 1.

The straight table with dimension Category and concatenation over ProductNr. displays:

A               1

B               1

C               1

But what I need is every value given for the selected ProductNr. and the associated Category:

A               1,2

B               1,4

C               1,5,6

Are there any possibilities via set analysis? I have tried some, but nothing worked...

Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: Re: Get all field values

Expression: =concat( {1<Category=p({<ProductNr=p(ProductNr)>}Category)>} distinct ProductNr ,', ')

See attachment

8 Replies
Not applicable

Re: Get all field values

You can use the expression concat( {1} distinct ProductNr ', ') in combination with a straigth or pivot table (chart object)

sudeepkm
Valued Contributor III

Re: Get all field values

Please take a look at the example attached.

Employee
Employee

Re: Get all field values

Will this work for you?

-Greg

Not applicable

Re: Get all field values

Hi,

thank you all for your replies!

The challenge for me is to show only the values of Category associated with the selection in ProductNr., so when making the selection ProductNr "1", Category D should not be shown inside the straight table...

Any further hints?

MVP
MVP

Re: Re: Get all field values

Expression: =concat( {1<Category=p({<ProductNr=p(ProductNr)>}Category)>} distinct ProductNr ,', ')

See attachment

anbu1984
Honored Contributor III

Re: Re: Get all field values

Try this

Not applicable

Re: Get all field values

Thank you - this is it :-)

Not applicable

Re: Get all field values

Would work, but would require additional effort inside the datamodel - thank you anyway!

Community Browser