2 Replies Latest reply: Dec 31, 2014 8:01 AM by Jon Cajacob RSS

    Filtering Dimensions with a formula

      Hi everyone,

       

      I am new to QlikSense and I have a rather basic question: I try to set up a table which has only two rows:

       

      - FinancialAccounts (drill down dimension with 3 levels)

      - Values (measure: sum() )

       

      Now what I try to do is to "pre-filter" the dimension "Financial Account" in the respective formula, so that only the Accounts are shown, which have the ID = 11. This concerns only the first level of the drilldown.

       

      I know there is the possibility to filter the values in the measure with:  sum({$<FinancialAccountsID={"11"}>}Values)

       

      But then the table does not show anymore the first level of the drilldown - it only shows the second level!

       

      I tried the following (formula in the dimension), which did not work: if(FinancialAccountsID={"11"},FinancialAccountsID,null())

       

      I hope you guys can help me!