2 Replies Latest reply: Jun 15, 2017 8:44 AM by Sebastian Londono RSS

    Need some help

    Ramakrishna P

      I have below questions

      1) I have 4 charts in sheet, when I select value in filter only three charts should be change and fourth chat will not be reflected. How can we achieve this.

       

      2) When we have compound key in the script, how the incremental load will process?

       

      3) I have top 5 products in bar chart based on sales, Now I want display their sum sales value as KPI .

       

      Regards,

      Ram

        • Re: Need some help
          Kaushik Solanki

          Hi,

           

          Find the comments for respective questions below.

           

          1. This can be achieved using the Set Analysis in Qlik.

           

          2. This depends on the scenario. But you can have a look at the incremental script in below link.

          Incremental loading - All scenarios

           

          3. This you can code using the set analysis.

           

          Regards,

          Kaushik Solanki

          • Re: Need some help
            Sebastian Londono

            1. You can ignore the selections with Set Analysis. For example Sum({<Year=>}Sales). That will ignore the selections in the fiel Year. Or you can use Alternate Estates

             

            2. I dont really know n,nU

             

            3. Kaushik, you can not do it with set Analysis because the top are dynamical. Maybe something like Numsum(Substring(Text_with_the_values in order,',',4)) but i dont really know in this moment how to order the values in a text string