topic Re: How To Insert Empty Row In Pivot Table and Straight Table in QlikView

How To Insert Empty Row In Pivot Table and Straight Table

nihhalmca — Wed, 04 Dec 2013 08:11:47 GMT

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.

Re: How To Insert Empty Row In Pivot Table

brijesh1991 — Wed, 04 Dec 2013 08:42:38 GMT

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

Re: How To Insert Empty Row In Pivot Table

nihhalmca — Wed, 04 Dec 2013 08:55:06 GMT

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.

Re: How To Insert Empty Row In Pivot Table

Wed, 04 Dec 2013 08:59:48 GMT

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!

Re: How To Insert Empty Row In Pivot Table

nihhalmca — Wed, 04 Dec 2013 09:23:08 GMT

Hi Shyamal,

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

Regards

Nihhal.

Re: How To Insert Empty Row In Pivot Table and Straight Table

jagan — Wed, 04 Dec 2013 10:25:07 GMT

Hi,

Can you attach sample data and qlikview file?

Regards,

jagan.

Re: How To Insert Empty Row In Pivot Table and Straight Table

nihhalmca — Wed, 04 Dec 2013 11:28:50 GMT

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.

Re: How To Insert Empty Row In Pivot Table and Straight Table

stevedark — Wed, 04 Dec 2013 18:46:57 GMT

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

Re: How To Insert Empty Row In Pivot Table and Straight Table

Thu, 27 Nov 2014 06:43:58 GMT

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