Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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

See attachment

View solution in original post

8 Replies
Not applicable

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

sudeepkm
Specialist III
Specialist III

Please take a look at the example attached.

Greg_Williams
Employee
Employee

Will this work for you?

-Greg

Not applicable

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?

tresesco
MVP
MVP

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

See attachment

View solution in original post

anbu1984
Master III
Master III

Try this

Not applicable

Thank you - this is it 🙂

Not applicable

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