4 Replies Latest reply: Feb 10, 2012 8:51 AM by Edgar Kech RSS

    How to create object independent of other selections on sheet

      Hi There... Does anyone know how to create an object that is independent of the selection on the same sheet.

      Example. I want to create a chart that displays all accounts that was opened in the selected year and show how their status changed over the years to follow.  The data is on transaction level . Other charts on the sheet will show the count of accounts that was opened in the selected year ='Count({<[NEW ACC] = {"Y"}>} DISTINCT [ACC NUMBER])' .

       

      The new chart will be a pipeline that links on the account number and displays a count per status per year to follow.

      Hope this makes sense.

        • How to create object independent of other selections on sheet
          Celambarasan Adhimulam

          Hi,

               You can exclude the selection by using set analysis by using the "fieldname=" inside the set analysis part like below.

                =Count({<[NEW ACC] = {"Y"},Year=,Month=>} DISTINCT [ACC NUMBER])

           

          In the above expression year and month selection will be excluded. You can use the fields that you want to exclude in that way.

           

          Hope it helps

           

          Celambarasan

            • Re: How to create object independent of other selections on sheet

              Hi there

               

              Thank you for the fast response.

               

              One more problem with this... because the data is on transaction level, this does not work.

               

              Example of data:

              Year      Account No      New Account      Status      Current Transaction

              2009      123            Y      Open      

              2010      123           Open      

              2011      123           Open      

              2012      123           Closed            Y

               

               

              Chart 1 On the selection of 2009 it will count this as a new account.    

              =Count({<[ New Account ] = {"Y"}>} DISTINCT )

              Char 2 Needs to show what is the current status of the accounts selected under new accounts for 2009.

              =Count({<[Current Transaction] = {"Y"},Year=>} DISTINCT ) - by doing this it counts all the transactions with Current status = Y and not only the accounts that had a New Account indicator in 2009.

               

              I need a way to hold the account numbers selected by the main selections.

               

            • Re: How to create object independent of other selections on sheet
              Edgar Kech

              If you are working with QV11 you could try to implement it via "alternate states" - just start with looking at the "whats new in Qlikview11"-example (Tabs "Product Grouping" and "Sales Overlap") to get an idea how alternate states work.

              Hope this helps,

              Edgar