1 Reply Latest reply: Oct 2, 2014 12:37 PM by Srinivas Chitrapu RSS

    Variable in Straight Table calling Selected Value

      Hi,

       

      I have an expression:

       

      Sum({<[4_WEEK_ROLLING_RETAIL]={"P4WTY"}, BRAND_NAME={"DRUG_ONE"}>} TRX_QTY_NORM)

       

      The expression returns BRAND_NAME from several values that can be filtered from a separate table:

       

      BRAND_NAME

      DRUG_ONE

      DRUG_TWO

      DRUG_THREE

      DRUG_FOUR

       

       

      Is there a way to write the expression so instead of having “DRUG_ONE” hard-coded in the expression, it is a variable that inserts the selection from the BRAND_NAME table?

       

      So, if a user selects BRAND_NAME > DRUG_THREE, then QV automatically inserts “DRUG_THREE” in the expression and returns the correct filtered value.

       

      I would prefer not to use the BRAND_NAME external filter for this.  I would like to make it function from the expression.

       

      Is this possible?

       

      Thanks, JV

        • Re: Variable in Straight Table calling Selected Value

          Not sure i got your question quite right but the way qlikview works is if you dont mention anything about the Brand name in your set it defaults to all brands. when user selects a brand from the list box the result will be for the selected brand.

           

          Sum({<[4_WEEK_ROLLING_RETAIL]={"P4WTY"}>} TRX_QTY_NORM)


          this expression will gives the result for the selected brand and all sales when no brand is selected.


          please post more details if this is not what your expecting.