topic Re: Questions pivot table qlik sense in QlikView

Questions pivot table qlik sense

Anonymous — Thu, 18 Oct 2018 11:42:12 GMT

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

Re: Questions pivot table qlik sense

dplr-rn — Thu, 18 Oct 2018 18:04:10 GMT

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

Re: Questions pivot table qlik sense

lironbaram — Thu, 18 Oct 2018 18:23:20 GMT

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