4 Replies Latest reply: Jan 19, 2017 5:31 AM by Sunny Talwar RSS

    Count on value list

    Max Goldshtein

      Hi Qlik

       

      Thank you for helping.

      I have column called 'P' in one table.

      In another table i have column called 'reason'. I joined 2 tables by 2 keys: seriesID and StudyID (not in Load Editor).

      Now i want to count how many seriesID is in 'P' column and has 'FP' values in 'reason' column.

       

      My example is just on one coumn called 'P'. The data includes more colums that i need to count in (So my value list would be with more values).

       

      This is my expression:

      DIM:

      ValueList('P')

       

      MEASURE:

      IF(ValueList('P')

      = 'P',

      count({$<result={"FP"}>}result))

       

      However, the result i got is total count of 'FP' values in 'reason' column (Not just the count of 'P' matching the seriesID).

      Thank you for helping.