topic Re: How to set default filter from Fac table in Graph ? in QlikView

How to set default filter from Fac table in Graph ?

ingridhusby17 — Wed, 25 Nov 2020 16:16:04 GMT

Hi there.

I am quite new to qlik and are trying to find an easy way of filtering data into a grapf element containting about 10-20 mesures.

We ar using the graph object to display the data as a table.

In my fac table I have a concatenation of 4 different select, and unfortunately all the dimensions are not apparant with all the sub-selests.

In my graph element i want to show only the rows from one spesiific sub-wuery, not all of them.

I have a fieldname 'Source' .

So in plain SQL it would be 'Where source = 'CUSTOMER_SALES' ; ( one of the four subselects in the fac table )

I will use other parts of the dataset in other tabs.

I am in qlikview not qliksence.

I know it is possible to alter column/measure by column/measure, but is it really the only posibility ?

Any help would be appreaciated.

Ingrid

Re: How to set default filter from Fac table in Graph ?

marcus_sommer — Wed, 22 Feb 2017 14:44:13 GMT

You could filter the chart within the dimension with something like this:

if(source = 'CUSTOMER_SALES', YourDimension)

and hiding NULL's on this dimension or with an expression like:

sum({< source = {'CUSTOMER_SALES'}>} Value).

- Marcus

Re: How to set default filter from Fac table in Graph ?

ingridhusby17 — Wed, 22 Feb 2017 15:57:26 GMT

Hi Marcus

Thank you for answering me .

I guess that will do what I want on one single column, but will it prevent data from other sub-queries in my other columns in the table ? ( table in the Graph obkect ).

Ingrid