9 Replies Latest reply: Jul 28, 2013 2:49 AM by Kaushik Solanki RSS

    How to Ignore field selection which is in dimension using set analysis

      Hi All,
      I am facing problem in the below mention calculation:
      ProductMarketunitsHeader 4Header 5Header 6
      A1A

      207454

      A2A5457
      A3A457
      A4A356
      A5A5724
      B1B2457
      B2B4577
      B3B23475
      C1C756
      C2C754275
      C3C324
      C4C57425
      C5C4257
      C6C547547
      Now I have a straight table in QlikView wherein my dimension is: If(Product='A1' or Product='B1' or Product='C1', Product) so that it shows only three products
      and my expression for market share is sum({<xyz>} units / Aggr(sum({<xyz>}units),Market) and it works absolutely fine, but the moment I select any particular brand(Say A1) in the list box then the denominator of the expression returns value only for the selected product and for other two markets/products it becomes ZERO.
      It will be of great help if anyone can help me out.
      Regards
      Sagar Gupta