topic Re: Pivot rows disappearing in QlikView

Pivot rows disappearing

xtrimf — Wed, 21 Aug 2013 13:30:39 GMT

Hi,

I have a pivot table - for each level its different calc...

It is built as a Hierarchial Tree. it means fo all rows the "drill down" is ending in a different dimensionality() (Depth);

the problems:

1 - when expanding a dimension that on a "brach" that has ended - the row disapear.

2 - also other rows disapear.

Attached is an example.

is there a way for rows not to disapear(I have to use suppress null values) ?

Re: Pivot rows disappearing

alexandros17 — Wed, 21 Aug 2013 13:39:42 GMT

IN your expression you have to add the second condition that is:

(if(Level = Dimensionality(),Value,0))

...

It works

Hope it helps

Re: Pivot rows disappearing

xtrimf — Wed, 21 Aug 2013 14:45:26 GMT

Hi,

It didnt work for me...once I expanded >-a->b->

most of the rows disapeared....

Re: Pivot rows disappearing

xtrimf — Wed, 21 Aug 2013 14:46:48 GMT

In cluding the 'b' row ...and i still have to keep the original value when its not disapearing....

Re: Pivot rows disappearing

alexandros17 — Wed, 21 Aug 2013 14:52:36 GMT

Uncheck suppress 0 value in presentation tab

Re: Pivot rows disappearing

xtrimf — Wed, 21 Aug 2013 14:59:08 GMT

I did...

Re: Re: Pivot rows disappearing

alexandros17 — Wed, 21 Aug 2013 15:11:48 GMT

Take a look to the modifyed document

Re: Re: Pivot rows disappearing

xtrimf — Wed, 21 Aug 2013 15:18:28 GMT

I'm sorry - I can't see what has changed.

in "calc ver 1" when you expand it still disappears (at least on my computer...)

Re: Pivot rows disappearing

xtrimf — Thu, 22 Aug 2013 14:52:04 GMT

anyone?

Re: Re: Pivot rows disappearing

dasilva — Tue, 24 Sep 2013 09:38:00 GMT

Hi,

Have you found a solution?

What version of QV are you using? Do you have the same problem if you create a pivot table with the same calculation for all dimension (but still use "show all values")?

I'm having this problem in pivot tables (QV 11 SR2) and wonder if it might have something to do with "Show all values"!?

Cheers,

Ulli

Re: Pivot rows disappearing

dasilva — Fri, 27 Sep 2013 08:22:01 GMT

Hi again,

At least in my case this was caused by "Indent mode"; if I removed this everything works ok

Ulli