Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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 (2)
1 Solution

Accepted Solutions
Arthur_Fong
Partner
Partner

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
Partner

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