Discussion Board for collaboration on QlikView Management.
I have raw Data as attach file and I need to count Sale person who can reach KPI by month.
1. Amount more than KPI then will Count distinct from Sale_id
2. The correct result is
There you go:
Create flag at script level to determine Amount > KPI.
Refer attached qvw for reference.
Thanks and regards,
View solution in original post
See result as picture
@Sunny Talwar Need your help.