topic button object in pivot table in QlikView

button object in pivot table

abc_18 — Thu, 11 Jun 2015 12:35:33 GMT

Hi,

How to show only one row at a time,while others field values remain unselected in pivot table.

I want to use button for this, so if I click on button object it should select one row value under first dimension, while others remain unselected..

Re: button object in pivot table

awhitfield — Thu, 11 Jun 2015 13:40:01 GMT

Why not just use a list box with the dimension you require in it and select from that, one value at a time?

Andy

Re: button object in pivot table

abc_18 — Fri, 12 Jun 2015 05:56:03 GMT

Hi Andrew,

I can use list box,but it will give only row value that I will select from list box drop down.

in my application customer requirement is like if they click on one filed value in pivot table then total should display,(in this case total revenue is field value ) while others field values remain expanded.

if I use list box then it will display only one field value.

I have used pivot table properties to show total by selecting show partial sum check box, but in this application so many expressions are there , so its not displaying total value at last, so I am trying to do that by using Button object(select in field option.)