Is it possible to suppress all but the first cell of a pivot table ?

[#1]

Hi Folks,

I have a pivot table object in my QlikView dashboard in which I want to display an 'Awaiting data' message in the first cell of the table. How do I suppress repeating this text in the other cells of the row ?

Thanks

MV

[Chanty4u]

u can create a textbox object over there and  unchk the move or size   option in layout

[#3]

I'm sorry but I'm not sure I understand you. Can you explain in more detail with steps please ?

[rubenmarin]

Hi Maureen, maybe checking the row and column in the expression:

If(RowNo(TOTAL)=1 and ColumnNo()=1, 'Awaiting data')

[#5]

I used your suggestion as the expression but it didn't display in any cell.

[rubenmarin]

Hi Maureen, the idea is set a condition that will be true only in that cell, maybe with:

If(Dimensionality()=0 and ColumnNo()=1, 'Awaiting data')

If doesn't works, please upload a sample with your table format.

[Saravanan_Desingh]

Are you trying something like this?

[Digvijay_Singh]

Try this -

if(rangesum(0,RowNo())=0 and rangesum(0,ColumnNo())=1,'Awaiting Data','')

[ramasaisaksoft]

Hi Maureen,

for suppressing data you can select the filed and select the option like below attachment.