Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Can you send me the file .qvw?
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().
OK, TX
Hi Kris,
I want results as image2. I want all four records with no '+' icon if values are not present.