How To Insert Empty Row In Pivot Table and Straight Table

[nihhalmca]

Hi All,

I want to insert empty row in ivot table and Straight table, Please let me know anybody knows for example:

Product        Country           Sales
  A                  India              2000

  B                  Usa               1500

empty row ---------------------------------------

  C                  Japan            1000

empty row ----------------------------------------

  D                  UK                 1800

Regards

Nihhal.

[brijesh1991]

In short you want to separate your products in Pivot Table... right? There are two ways: 1) Go to Presentation Tab: And check 'Show Partial Sum' for Product Field 2) By changing color of products: For example: Product A, B in red color, C in Blue and D in green color::: In Dimention Tab; Edit Product Dimention: If(MixMatch(Product='A','B'),red(), if(Product='C',blue(), if(Product='D',green())))

[nihhalmca]

Hi Brijesh,

Thanks for reply, i hope you did not understand my quesrion no problem i explain in simple words, just i want to insert 'empty' row in pivot table

Regards

Nihhal.

[#4]

Hi Nihhal,

Might be something like below:

If so, then you can go to Properties--Presentation tab and enable partial sum, once done then give a space in the "Label for Total" and then change the color of text (total which will be displayed) to white or whatever background color you have.
Let me know if this helps!

[nihhalmca]

Hi Shyamal,

I want empty row for across all fields, please see my example

Regards

Nihhal.

[jagan]

Hi,

Can you attach sample data and qlikview file?

Regards,

jagan.

[nihhalmca]

Hi Jagan this is sample Pivot chart and source is inline just i want to add empty row between product 'C' and 'D' rows

Regards

Nihhal.

[stevedark]

This is might be problematic in a Pivot, less so in a straight table.

If you load an INLINE table that has values like this:

Order,Product,Counter

1,A,1

2,B,1

3,,1

4,C,1

5,,1

6,D,1

You can add an expression to your table of SUM({1}Counter) and this will ensure all rows show.  You will need to add Order as a Dimension and sort by it.  In presentation you can then choose to hide both the Order and sum of Counter columns.  This should leave you with a table like you are after.

It is more tricky in a Pivot as you do not have the option to hide columns, but you may be able to use a similar technique.

Hope that points you in the right direction.

Steve

[#9]

Hi,

I have created Straight table and I want to Insert blank row after each record.

Please suggest the same that how to insert the blank row.

Regards

Amol Khochare