Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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