Pivot Table

[NavinReddy]

Hi All,

I have one pivot table

When i select any value in list box ,if value is null mean The table size should become small

how can i make it table should be same size ,if it value '0' also pivot should be same size

Please find the image

Thanks In Advance

Niru

[NavinReddy]

yes but its confidential data i cant

give me expression example

[giakoum]

here you go

[NavinReddy]

Hi,

in list box i have some fields '0' value

if i click that field in list box , pivot table have to show 'No data'

how can i do this some one guide me

Regards,

Niru

[#5]

Could you try to map between the 2 tables for '0' value as 'No data'  in the script and simply fetch the field in the pivot table.

[NavinReddy]

Hi,

How can i will you please explain me

Regards,

Niru

[#7]

1) Check the relation between listbox field say A with pivot table field B

2) In script whenever A = 0; then B= 'No value'- use applymap

eg:

Tab1:

Mapping load

key,

A;

tab2:

Field1,

Field2,

Applymap('Tab1',B,if(A==0,'No Value',B) as B

..

3)Reload A,B with other fields and fetch the fields in pivot table and list box and check it out

I am not sure about the relation between the fields in detail, but this another way of doing

[NavinReddy]

Hi,

Sorry im totally confused City Name is the list box

if New York=0,

How can i show in pivot table No Data

Please guide me

Regards,

Niru

[#9]

you can use GetFieldSelections to fetch the exact field value 'New york' from City Name and use the same expression in the apply map.

[stevedark]

If you want to show zeros you may be able to achieve this by checking include zeros on the Presentation tab, and then alter your expression to include a set that ignores selections, eg:

=sum(Value) + (sum({1}Value) * 0)

It's a bit of a fudge, but {1} in the expression is Set Analysis syntax for ignore selections.  You will then get a value for all dimensions - regardless of selections.  However, this value is removed by multiplying it by zero.

If you would rather just hide the pivot and show a message instead you can use Conditional Shows.  Place a conditional show on the pivot (on the Layout tab) of:

=sum(Value) <> 0

Obviously the expression will need to match the expression in your Pivot.  You can then create a Text Area with a message such as 'No Values Found For the Current Selection', and set a corresponding Show Condition on that also:

=sum(Value) = 0

If you have both positive and negative values and there is a risk that positives in one dimension will be netted off by negatives in another you may need to use an AGGR statement - but don't worry about this if you don't have to.

Hope this points you in the right direction.

On using Show/Hide conditions, you may find this example document useful:

QlikView App: At The Qlik Of A Button

Steve