Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Questions pivot table qlik sense

Hi,

I would like to ask questions about pivot table.

First, is there any way to get rid of the 'value' sign in the column(as shown).

second, how can i get the average value for the others & totals (as shown)? it would make more sense to use the average value for these three columns. but i used one row so not sure how to make different expressions for measures. Thanks so much!!

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

not 100% but i dont think it can be removed. You will need an extension

one work around is replcing label as =chr(32) but it still shows the search icon

lironbaram
Partner - Master III
Partner - Master III

hi

for the first question, i don't think you can hide the value button

for the second question you can use avg function in the expression

so the total will also be avg