4 Replies Latest reply: Mar 29, 2015 12:00 AM by Michael Gardner RSS

    How to implement AND operator for values from same column

    Siddharth Kulkarni

      Here we go-

       

      Data looks like:

       

      Sales:

      Customers, Bikes, Sales

      Mike,          A     , 10  

      Mike,          B     , 10

      Steve,         A     , 10

      Laura,         B     , 10

       

      Problem Statement: Display only those Customers who have bought both Bikes- A as well as B

      Expected Result: Mike

       

      How do I achieve this using:

      1. Qlikview Backend (Scripting Only)

      2. Qlikview Front End (UI Only)

      3. Not in Qlikview , but In SQL while loading data.

       

      Quick turnaround will be appreciated.

      Thanks in advance, geeks!