6 Replies Latest reply: Aug 28, 2018 9:45 AM by David Štorek RSS

    count and not contains

    ibrahim aljafri

      hi Qlikers

       

      i have created below inline table in order to execute below logic at front end using set analysis  :

       

      (#distinct benefeciaryTransactionLog.BenefeciaryID where benefeciaryTransactionLog.TransactionType = 2)/

      (#distinct benefeciaryTransactionLog.BenefeciaryID where benefeciaryTransactionLog.TransactionType in (1,7,8) and not in (2))

       

       

      TT:

      LOAD * Inline [

      TRANSACTION_TYPE,BeneficiaryID

      1,1

      1,2

      2,3

      2,2

      7,4

      8,5

      2,8

      1,8

      7,8

      1,9

      2,10

      2,11

      7,11

      1,12

      2,12

      7,12

      8,12

      1,13

      7,13

      8,13

      ];

       

      please help

      note the actual data is more than 65 m and i am using qlik sense