Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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
Partner
Partner

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

Partner
Partner

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