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: 
upaliwije
Creator II
Creator II

Blank Row

Hi Friends

I have in QV doc the following  Pivot Table

Screenshot_1.png

I want to insert a blank row in between PRD_CODE and report should look like below

Screenshot_2.png

Pls help me to this since what I tried did not work. I attach My QV Doc as well

2 Replies
vinieme12
Champion III
Champion III

I'm using Personal Edition so can't open your app. Check the attached sample

Just concatenated blank rows for Distinct Dimension values

In Script 

Concatenate(Transactions)

          LOAD Distinct Dim1,

              ' ' as Dim2                                          //Adding Blank dimension Rows

          Resident Transactions;


Chart Expression

if(sum(Expression1)=0,'',num(sum(Expression1),'$ ##,###'))


blankRowsPivot.JPG

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

Thanks Vineeth,

It is bit difficult for me to apply your one to my Qv Doc