Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
niccolo24
Contributor II
Contributor II

drilled out values show in listbox

Hi,

i have created a drilldown dimension with 4 product levels (from aggregation to most detailed level). When I put the dimension in a chart it is very easy to drill down, but I always have a legend that shows also excluded variables, that i do not want to see while i drill down.

I need to NOT show the excluded values both in charts and list box properties.

How can i do this??

Tx

11 Replies
anbu1984
Master III
Master III

Can you post sample qvw

marcarreras
Specialist
Specialist

Niccolò,

Inside a graph, if you use drilldown dimension and you want to avoid excluded, you need to select 'Supress when value is null' in graph properties.

On the other hand, if you have a list and your purpose is to not show excluded, you will have to use the Aggr function as I told you.

I understand you need to use both, in the graph and in the list object.

Salute.

Marc.