Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Use Columns as filter in Qlik Sense

Hi,

I have a Excel database with several columns standing for KPIs.

I'd like to use each column as a filter for graphic. For example: when I pick the column I want the matching graphic appears.

Is it possible to do it ?

Thanks in advance !

3 Replies
tajmohamed30
Contributor III

Re: Use Columns as filter in Qlik Sense

what is the graphic here, whether it is image

rohitk1609
Valued Contributor II

Re: Use Columns as filter in Qlik Sense

HI Gabriel,

What you are looking , we call it bundling images with apps. Please go through these tickets,it will guide you how to do it.

Load images into Script

Qlik Sense - Bundling Images with Apps

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

OmarBenSalem
Esteemed Contributor

Re: Use Columns as filter in Qlik Sense

I kind of get what you're trying to do, correct me if I'm wrong;

You have some Kpi columns (fields in Qlik)

Example: Sales, Margin and let's say, Budget

What you want is having a filter containing 3 values : margin, sales, budget.

when you click on budget, you have your chart showing sum(Budget) by dimension;

when you click on sales, you have your chart showing sum(Sales) by dimension and so on ; right?

If that the way it is; what you should do is creating an inline table containing the margin, sales, budget. values:

Load * inline [

KpiID, Kpi

1, margin

2, sales

3, budget

];

Now you choose this new Kpi field as a filter in your sheet.

And in your chart(s); change the measure as :

sum(Pick(KpiID,Margin ,Sales,Budget))

with that, depends on the selection you make, you'll have the chosen measure appearing in your chart.

You can even add an information on the title of the chart to specifiy which KPI you're working with:

=Kpi&' by dimension'

Hope this helps

Community Browser