Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

8 Replies
Chanty4u
MVP
MVP

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

Not applicable
Author

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')

Not applicable
Author

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','')

Capture.JPG

ramasaisaksoft

Hi Maureen,

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