3 Replies Latest reply: Jun 6, 2017 3:35 AM by omar bensalem RSS

    Use Columns as filter in Qlik Sense

    Gabriel Maya Pinheiro

      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 !

        • Re: Use Columns as filter in Qlik Sense
          taj mohamed

          what is the graphic here, whether it is image

          • Re: Use Columns as filter in Qlik Sense
            Rohit Kumar

            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.

            • Re: Use Columns as filter in Qlik Sense
              omar bensalem

              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