topic Re: Blank Row in QlikView

Blank Row

upaliwije — Sun, 27 Aug 2017 08:52:48 GMT

Hi Friends

I have in QV doc the following Pivot Table

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

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

vinieme12 — Sun, 27 Aug 2017 09:35:56 GMT

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

upaliwije — Mon, 28 Aug 2017 03:08:58 GMT

Thanks Vineeth,

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