How to set default filter from Fac table in Graph ?

[ingridhusby17]

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

[marcus_sommer]

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

[ingridhusby17]

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