Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

Use Pivot table Count Sale who can reach KPI

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 

 

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

Create flag at script level to determine Amount > KPI.

Refer attached qvw for reference.

Thanks and regards,

Arthur Fong

View solution in original post

3 Replies
panwipa2528
Contributor III
Contributor III
Author

See result as picture

panwipa2528
Contributor III
Contributor III
Author

@Sunny Talwar Need your help.

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

Create flag at script level to determine Amount > KPI.

Refer attached qvw for reference.

Thanks and regards,

Arthur Fong