topic Re: How to display filtered pivot table when click on a text box object. in QlikView

How to display filtered pivot table when click on a text box object.

jim_chan — Thu, 13 Oct 2016 03:50:25 GMT

Hi guys,

I want to find out whether this requirement can be achieved or not. i have attached a sample.qvw file here.

1) i have a textbox with to state that - For Group A, there;s 3 record_ID. expression that i use for this text box is

=count({$<Group={'A'}>}Record_ID)

2) Now, i got the number already. So , i want to click on the textbox(with 3 records counted) , to display out a pivot table.

3) this pivot table is a general pivot table, meaning just 1 pivot table.

4) So, when I click on textbox(shows 3 records) , the below pivot table with be filtered and only show Group A - 3 records details only.

Rgds,

Jim

Re: How to display filtered pivot table when click on a text box object.

jonathandienst — Thu, 13 Oct 2016 04:33:23 GMT

Add a Select in Field action (to select Group = 'A' or 'B' respectively) and a Set Variable action to toggle a variable value. Finally, use the variable in the pivot table's conditional show expression.

You could dispense with the variable if a selection on Group is enough to control the visibility of the pivot. Use something like this in the Show condition:

=GetSelectedCount(Group)

Re: How to display filtered pivot table when click on a text box object.

tamilarasu — Thu, 13 Oct 2016 04:46:21 GMT

Jim,

Like attached.?

Re: How to display filtered pivot table when click on a text box object.

jim_chan — Thu, 13 Oct 2016 05:52:08 GMT

Thanks Jonathan!

Re: How to display filtered pivot table when click on a text box object.

jim_chan — Thu, 13 Oct 2016 05:52:53 GMT

Tamil ,

Yes it is. that's what i wanted to achieve! thanks!

Rgds,

Jim