topic Pivot table dimension values in QlikView

Pivot table dimension values

Thu, 12 Nov 2009 18:42:20 GMT

Hello,

I´ve got a problem that can be demonstrated on QlikView example file Presidents.qvw.

On tab Pivot table there is a presidents timeline pivot table and I need to modify the functionality a bit.

The timeline itself looks as on the attached picture (part 1). That is ok. But when you restrict the filtr to show just Republican party, you will get same state as on the picture part 2.

But I wish pivot table to show me even the empty cells which are surrounded by coloured cells, so something like part 3 on attached picture.

In this case it is not a problem to select "Show all values" on No. dimension, but in my case, I have a 5 years timeline and I want to show just relevant data.

Can anybody help me? Thank you

Tomas

Pivot table dimension values

kji — Thu, 12 Nov 2009 19:11:53 GMT

Try to set "Show all Values" (Dimension tab) for the Sequence Dimension, and remove "Supress Zero-Values"(Presentation tab).

This will however give "0" for empty slots, which can be removed by setting Text Color to white for non party matches on the expression.

Pivot table dimension values

Mon, 16 Nov 2009 17:23:52 GMT

Hi,

thank you for feedback, but this will show all values of horizontal dimension (from 1 to 40), I think. I need to keep only values associated with Republican Party (16-38), and omit other. Just to keep values surrounded from both sides with green fields.

In this case it's propably irrelevant, but I have similar problem with a horizontal time dimension containing 3 thousands values, and need to show task solution timeline.

Thanks

Tomas

Pivot table dimension values

sparur — Mon, 16 Nov 2009 17:46:57 GMT

Hi, Tomas.

Do this:

1) Chart properties/Dimension Tab/

Dimension "Sequence" Show All Values - CHECK

2) Chart properties/Presentation Tab/

Suppress Zero Values UNCHECK

After these steps you will see 0 value!!! If you don't want see zero then you should correct expression:

if (count(Name) = 0, '', count(Name))

After this you will see chart as figure 3.

regards Anatoly

Pivot table dimension values

Mon, 30 Nov 2009 17:38:39 GMT

Hi Anatoly,

thank you for post, and please accept my apology for late response.

This method is functional, but after selecting Republican as a filter, I can see all values (1-45), not just the interval, when Republican Party presidents were involved (16-43). I need to remove outer values, and keep the rest, as on figure no.3.

I thought about a solution, and the only possible method (in my opinion) is creating a virtual president for each party, which would reign for the entire period, I would like to show in a table. Using aggr function and min and max.

Tomas