Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

pivot table if i dont want a avg value for a field

pivot table if i dont want a avg value for a field which is round markedpivot 1120.PNG.png

5 Replies
sujeetsingh
Master III
Master III

You need to use a straight table to implement this.

You want to change the Total.

Please provide a sample or explain in more words what dimension and expression you are using.

Anonymous
Not applicable
Author

yaa its all created in pivot but i dont want averages for percentages for target % and passrate at total field only.

Anonymous
Not applicable
Author

here i should want like this that target % value is nulll and i want passrate also kept null(

morgankejerhag
Partner - Creator III
Partner - Creator III

You can check the value of you dimension - if it is null then it is on the total line. See attached example.

Anonymous
Not applicable
Author

can u please give me u r mailid

i wanna talk to u ..plsss its urgent