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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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!!

Labels (1)
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