Excluding values from drilldown

[Anonymous]

Hi all,

New to Qlik..

I have created a drilldown including data I want to exclude on different levels.

Can anyone take me through how to do this, step-by-step?

Thank you in advance.

Best,

Nicolas

[undergrinder]

Hi Nicolas,

could you provide us some example?

Do you want exclude data only in drill down level, or absolutely from the application?

Exclude facts related to dimension, or dimension value?

G.

[Anonymous]

Hi Gabor,

I would like to exclude the data on the drill-down level.

In some graphs it is related to dimension - so I have a scatter chart with Australia and regions within Australia. I want to exclude 1-2 regions.

Then in other graphs, I am showing the growth of sales in different products. I would like to exclude some products, in a pre-defined market - this is also dimension related.

Can some formula be inserted to exclude values with a certain name?

Hope this clarifies?

Best,

Nicolas

[rangam_s]

in the master dimension, apply if condition to exclude those items (like if(not wildmatch(Field, Exclusion Items),Field)).

Finally in the object select ignore nulls.

[undergrinder]

exactly, or there are many method to achieve this.

If that data is not requirement in the dashboard, I suggest filter out in load script with where [condition] block.

G.