topic Re: Filter only Drill-Down in App Development

Filter only Drill-Down

Anonymous — Thu, 14 Sep 2017 09:09:26 GMT

Hi everyone,

I'm using a table with a drill-down hierarchy. I'm trying to click in some fields and only filter this table.

The problem is that if I click in some fields on the table, all the other charts will change too according to the fields clicked.

I would like to click on the table and change only the table, without putting filters on the other charts.

Is it possible?

Thank you very much

Re: Filter only Drill-Down

Neymar_Jr — Thu, 14 Sep 2017 13:48:34 GMT

Hi Carina Rodrigues,

May be this might help -

Sum({1<Field1={'xyz'}>}Sales)

Using 1, as highlighted in the measure of chart that you don't want to change.

Thank you!

Re: Filter only Drill-Down

ggijben — Thu, 14 Sep 2017 14:22:47 GMT

Hi Carina,

You could use the option Rajesh mentioned, but then your other charts will respond to nothing anymore and become static charts.

Since the purpose of Qlik Sense is to create interactive and responsive dashboards, a better option is to just exclude the filters used in the drill-down.

Lets say you have a drill-down Productgroup > Product. You must add "Productgroup=, Product=," to the set analysis in your measure expression to achieve this functionality. Add this to every chart which you don't want to react to the active filters.

Re: Filter only Drill-Down

shraddha_g — Fri, 15 Sep 2017 04:44:38 GMT

There is one workaround.

You can create 2 replicas of fields that you want to create a drill down of.

For Ex. You can create 2 sets dimension such as Category & SubCategory and Category1 & SubCategory1.

Then use category1 & SubCategory1 for Drill Down Dimension and nullify those 2 dimension from all other measures when you want there selection unaffected.

as Sum({<Category1=,SubCategory1=>}Sales)