topic Re: Text fields called in the expressions in pivot table are not showing all the values in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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_h79‌youssefbelloum‌ any thoughts on this??

Thanks

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

YoussefBelloum — Mon, 02 Jul 2018 08:04:53 GMT

Hi,

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

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

Anonymous — Mon, 02 Jul 2018 08:12:23 GMT

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

Anonymous — Mon, 02 Jul 2018 08:13:33 GMT

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.

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

YoussefBelloum — Mon, 02 Jul 2018 08:14:58 GMT

what did you use as expression for:

the working BUSINESS UNIT

the working PRODUCT FAMILY

the non working PRODUCT GROUP

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

tresB — Mon, 02 Jul 2018 08:16:21 GMT

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

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

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

Anonymous — Mon, 02 Jul 2018 08:18:25 GMT

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 ?

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

YoussefBelloum — Mon, 02 Jul 2018 08:19:56 GMT

Try tresesco suggestion

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

Anonymous — Mon, 02 Jul 2018 09:11:26 GMT

This doesn't seem to work Tresesco

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

Anonymous — Mon, 02 Jul 2018 09:11:51 GMT

tried , but no luck..

Any other thoughts to deal with this?

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

YoussefBelloum — Mon, 02 Jul 2018 09:15:59 GMT

what are the dimensions used on your pivot table ?

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

Anonymous — Mon, 02 Jul 2018 09:17:34 GMT

survey id , date , region , country , vertical , application name , customer name, currency and rate

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

YoussefBelloum — Mon, 02 Jul 2018 09:19:14 GMT

try this:

=concat(aggr(only([product group]),survey id , date , region , country , vertical , application name , customer name, currency,rate),',')

verify your dimensions fields name on the expression

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

Anonymous — Mon, 02 Jul 2018 09:33:59 GMT

You can enable QMC Auditing using this setting, as in this post:

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

Anonymous — Mon, 02 Jul 2018 09:44:21 GMT

i am getting wrong results when used like this ,

i just simply want to display the related values against each business unit , with out concatenating.

if there are 3 products under one business unit then 3 lines of entries should come up in the pivot table,

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

YoussefBelloum — Mon, 02 Jul 2018 09:58:35 GMT

I don't think I will be able to figure it out before manipulating the table, it could be one expression used on the table that blocks the lines

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

YoussefBelloum — Mon, 02 Jul 2018 10:01:09 GMT

would you be able to share sample app that has the same problem ?

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

Anonymous — Mon, 02 Jul 2018 10:24:25 GMT

attached the sample file with scrambled data due to data sensitivity.

kindy help me out,, also kindly note i use desktop version of qlikview and cannot open any external qvq files.

kindly explain the solution with screen shots if possible also with explanation.

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

YoussefBelloum — Mon, 02 Jul 2018 10:41:13 GMT

Tresesco solution is working

for the selections above, you have 2 Product Group values, so Concat(distinct PRODUCTGROUP,',') is working fine.

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

tresB — Mon, 02 Jul 2018 10:43:05 GMT

If you need separate line items for separate values, use the field as Dimensions instead of expression.