Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Use the value of dimesion of pivot table

Hello,

how to use the value of on dimension of pivot table.

My table is like this

pivot_table_dimension.bmp

The dimension "Stock région" is num(aggr(sum({$<ANNEE_MOIS_CA={$(vMaxPeriode)},ABR_MAGASIN=>} MONTANT_STOCK),RECH_GROUPE_FAMILLE,LIB_PERIODE),'# ##0')

And i want to use this value in the pivot table to do for exemple 84 927 / 753 138.

How i can do this ?

Sophie

2 Replies
simospa
Partner - Specialist
Partner - Specialist

Hi Sophie,

did you try to create a variable containing your expression and use it?

S.

Anonymous
Not applicable
Author

Hi Simone,

yes it's not possible to do this because ABR_MAGASIN= in the pivot table erase my selection and i don't want to do this.

Sophie