How to show CASTIDs cancelled by?

[#1]

Hi,

I have to show CASTIDs cancelledby person, team and item. Please can anyone help me with correct expression. as I used one but not sure whether it is correct or not?

Thanks.

[er_mohit]

Yeah its write due to your Id which is unique

so if you replace distinct keyword then doesn't affect

Count(distinct (IF(notes='cancelled',FFTID)))

or

Count(distinct (IF(notes='cancelled',FFTID)))

or try this if you aggr it for three column

Count(DISTINCT aggr(IF(notes='cancelled',FFTID)

,Team,person,Item))

[#3]

Thanks and it is not showing the values correct when I complared the values in database. Do I need to change any thing?

[manojkulkarni]

use this in expression, Count(DISTINCT aggr(IF(notes='cancelled',ID),Team,person,Item))

[er_mohit]

Tell me what is actual output comes

[#6]

Thanks and again the same problem . As in the database for person= RTY where ID=9 the count is 150. but in qvw it is showing 1. Any thing do I need to change?

[#7]

I have to show this table in qvw.

[manojkulkarni]

Pls find attachment with expected result

[#9]

Thanks and i tried and again the same problem. is there any issue with expression?

[manojkulkarni]

can you upload qvw file ?