topic How to display values in pivot table in QlikView

How to display values in pivot table

Thu, 23 Dec 2010 12:35:41 GMT

Hi Everybody,

I want to display values which are not seleted but these are in table.

Such as I have two selection fields for year 1)Recorded Year (having values 2007,2008 ,2009,2010)

2)Contract Year (having values 2007,2008 ,2009,2010)

In this If I select 2007 in recorded year I want to show all values of contract year related to recorded year.Such as 2007,2008 ,2009,2010 of contract month(If no there is no values for 2008 and 2009 )Still I want to show those coloumns of contract rate(i.e.all years)

I had used shoe all values option but does not give me solution

Please anybody can suggest me

Regards

Go....COOL

How to display values in pivot table

Thu, 23 Dec 2010 15:45:44 GMT

Did you try Show All Values on the Dimension tab? You want to modify Suppress Zero-Values and/or Suppress Missing on the Presentation tab. The results of those expressions when there is no data is either zero or null. The Suppress options hide zero and null values respectively. Try unchecking them to show the missing records.

How to display values in pivot table

Tue, 28 Dec 2010 10:22:50 GMT

Nmiller ,

Thanks for your inpiut but I had already tried these options...

Can you give me idea about how to hide perticular row in pivot table (such as '-' containing row I want to remove)

How to display values in pivot table

Wed, 29 Dec 2010 16:50:26 GMT

To hide a row in a pivot table, all expressions in that row must be null (-). Look at a record you don't want to show on your chart and make sure all values are null. If a value isn't null, then modify the expression, so it is null for those records you don't want to show.

How to display values in pivot table

Thu, 30 Dec 2010 06:55:38 GMT

Hi Nmiller plaese check attached application for understanding

How to display values in pivot table

Thu, 30 Dec 2010 06:58:20 GMT

Hi This is excelsheet for various approaches I had tried and problem description

How to display values in pivot table

marcohadiyanto — Thu, 30 Dec 2010 07:13:54 GMT

hi,

that's not subtotal,

you can try this:

go to your table, properties -> Dimension->support Month

and then setting for Selected dimension check 'Suppress when value is null'

regards,

Marco