topic Re: Can we customize the existing pivot table in QlikView

Can we customize the existing pivot table

Mon, 26 Jan 2026 16:26:21 GMT

Hi,

Can we customize Qlikview pivot table and use as a custom object. If yes, where can i find the qvpp & *.js files for the existing pivot table. The idea is to take the base files and do some changes to get the below functionality.

Deepak, It didn't worked

See images for what i tried.

The count i used in pivot table is Count(ID)

Image1: Data in table

Image2: Pivot table without suppress nulls(Highlighted area should not be coming)

Image3: Pivot table with suppress nulls(When i use this, it is removing whole record)

Re: Can we customize the existing pivot table

ecolomer — Tue, 12 Aug 2014 18:37:16 GMT

Can you send me the file .qvw?

Re: Can we customize the existing pivot table

Tue, 12 Aug 2014 19:06:48 GMT

I found a potential work-around. I added this as a calculated dimension for the first field (level01) and check Suppress When Value is Null, and it returns the correct lines. If any of the five fields are blank the result is greater than 0, so just show records that are zero:

if(match(len(level01),0)+match(len(level02),0)+match(len(level03),0)+match(len(level04),0)=0,level01)

In my sample data the empty fields came through as blanks and not nulls, so you may have to use isnull() instead of match().

Re: Can we customize the existing pivot table

ecolomer — Tue, 12 Aug 2014 19:20:36 GMT

OK, TX

Re: Can we customize the existing pivot table

Thu, 14 Aug 2014 15:40:53 GMT

Hi Kris,

I want results as image2. I want all four records with no '+' icon if values are not present.