Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Wahab
Contributor II
Contributor II

Filter Chart using dimensions only

Hi all, 

I have this sample dataset from one source.  I want to show in a straight chart, just the Store and Systems columns.  But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'.  Any help here would be appreciated, thanks in advance!

Labels (1)
2 Solutions

Accepted Solutions
MatheusC
Specialist II
Specialist II

Got it, so do this for these 2 dimensions just Store and Systems

Store

=Aggr(only({<Function-={'Reporting'}>}Store),Store)

Systems

=Aggr(only({<Function-={'Reporting'}>}Systems),Systems)

MatheusC_0-1715350252582.png

 


Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

Wahab
Contributor II
Contributor II
Author

Thank you MatheusC!!  That worked!!

View solution in original post

4 Replies
MatheusC
Specialist II
Specialist II

@Wahab 

Is this the result you want to achieve?

MatheusC_0-1715286003991.png

 

To do this, you can use the expression below, removing the 'Report'.

=Aggr(only({<Function-={'Reporting'}>}Function),Function)

uncheck null values.

Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Wahab
Contributor II
Contributor II
Author

@MatheusC thanks for the reply.  I want to only show the Store and Systems column, not the Function column.  The results look correct, but when I remove the Functions column, it doesn't filter to just those anymore.

MatheusC
Specialist II
Specialist II

Got it, so do this for these 2 dimensions just Store and Systems

Store

=Aggr(only({<Function-={'Reporting'}>}Store),Store)

Systems

=Aggr(only({<Function-={'Reporting'}>}Systems),Systems)

MatheusC_0-1715350252582.png

 


Regarts, Matheus



Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Wahab
Contributor II
Contributor II
Author

Thank you MatheusC!!  That worked!!