Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Text fields called in the expressions in pivot table are not showing all the values

HI Experts ,

i have mentioned few Text fields like product name , product brand in the expressions section in pivot table.

but all the values are not showing. only the first row comes up.

why is this happening ?? are'nt we supposed to call the non aggregated values in the expression section ??

Kindly help on this , this is kinda last moment issue and has to be fixed asap..

franky_h79youssefbelloum‌ any thoughts on this??

Thanks

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Yes, the could be the reason. If you want to display all the values, you could try using concat(), like:

=Concat(Distinct [Product Name] , ',')

View solution in original post

22 Replies
YoussefBelloum
Champion
Champion

Hi,

would you be able to show us the issue using a screen shot ?

Anonymous
Not applicable
Author

Capture.PNG

Anonymous
Not applicable
Author

there are multiple product brand names and product names. is that the reason they are not showing up ??

beacuse if i pass a single product name as a filter the table shows the values.

YoussefBelloum
Champion
Champion

what did you use as expression for:

the working BUSINESS UNIT

the working PRODUCT FAMILY

the non working PRODUCT GROUP

?

tresesco
MVP
MVP

Yes, the could be the reason. If you want to display all the values, you could try using concat(), like:

=Concat(Distinct [Product Name] , ',')

Anonymous
Not applicable
Author

in expressions i have given as below,

for business unit expression = Businessunit

product name = product name

under one kind of business unit there are multiple product names, lets consider there are 3 product names under business unit 1 .

so in the table business 1 will come up, but in the product names column the values are shown as -.

which is null or missing,

how should this be handled ?

YoussefBelloum
Champion
Champion

Try tresesco suggestion

Anonymous
Not applicable
Author

This doesn't seem to work Tresesco

Anonymous
Not applicable
Author

tried , but no luck..

Any other thoughts to deal with this?