Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

Getselectedcount in multiple fields

Hi All,

We are trying to show a drill down detailed report for the summary report attached in pic.Qlikview discussion.JPG

In the right hand side, it is a list box used as a filter with the same dimension in the layout.

When we select the dimension element either in table layout or from the filter we are getting the drilled down report. How can we overcome this.

Is there any other way where if we select the dimension element from the layout only should be drilled and if we select the dimension element from the filter the table should not be drilled.

The only expression used in the chart properties of detailed report is in the layout tab which is GetSelectedCount([Mat Desc])>0

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

There is no simple way to identify how an item was selected, and there is no function or facility to do so. You may be able to detect how something was selected by placing the list box in an alternate state and using set analysis to combine direct selections and selections in the alternate state.

But even if you could do this, you would not change the behaviour of the drill down dimension. This responds to the possible values that arise from the selections, regardless of where and how those selections are made.

One way around this, using the alternate states mentioned above, is to make two conditional dimensions. the dimensions would be selectively displayed, based on whether a selection is made to the alternates state, so the table can switch between a drill down and a normal field dimension. But it may be complex to achieve seamless and intuitive behaviour and you may simply confuse your users.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein