Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Creator
Creator

Pivot Table Blank Row

Hi, I have a pivot table that I have entered a blank row see Pivot table 1.  However the dashes appear.

In Pivot table 2, I have entered in the Expression =''.  The dashes disappear, though the label shows as ='.

My Ideal Pivot table is shown where there isn't a label showing and no dashes showing. 

How can I get to the Ideal Pivot?

MikeJones_0-1688634865411.png

 

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

Create an inline table and add blank rows using a blank space character

Dim_PnL_Report:
Load dual(Dim,recno()) as Dim,recno() as so_Dim
inline [

Dim,SortORder

Revenue,1

<PASTE BLANK SPACE CHARACTER HERE>‎,2

Costs,3

];

 

You can copy the blank space character from below

https://www.editpad.org/tool/invisible-character

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.