Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit Filtering to one chart

Hello

I have a dashboard with 5 charts and 4 KPI's. What I need is to click on one of the bars in the charts and filter only 1 KPI and 1 chart (made of the same measure).

Is it possible?

Thanks.

6 Replies
MK_QSL
MVP
MVP

Provide sample app.

Or try to search Alternate State...

Not applicable
Author

As i understand, its an extantion, am i right?

No way without extantion?

Thanks.

shubham_singh
Partner - Creator II
Partner - Creator II

Yes it is possible without any extension,

Although I need a sample app to do such changes but I hope you can understand via an example.

e.g.

You have Sum(Sales) in measure of a chart or a KPI and you want to make it independent of Customer,

simply write Sum({<Customer=>}Sales) in measure to do so.

Not applicable
Author

I want by clicking every component on the dashboar, filter only 1 KPI.

Not applicable
Author

do you want to drill down?

Thanks,

Prajna

rahulpawarb
Specialist III
Specialist III

Hello Max,

You can detach the rest of charts (strictly not recommended) or else make use of Alternate State. Please refer below link for more details:

How to use Visual Cues and Alternate States in QlikView?

http://www.learnqlickview.com/alternate-states-in-qlikview

Hope this will help.

Regards!

Rahul