Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bunnyv123
Creator II
Creator II

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.

bunnyv123
Creator II
Creator II
Author

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

bunnyv123
Creator II
Creator II
Author

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

morgankejerhag
Partner
Partner

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

bunnyv123
Creator II
Creator II
Author

can u please give me u r mailid

i wanna talk to u ..plsss its urgent