Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panwipa2528
New 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 

 

1 Solution

Accepted Solutions
Partner
Partner

Re: Use Pivot table Count Sale who can reach KPI

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

3 Replies
panwipa2528
New Contributor III

Re: Use Pivot table Count Sale who can reach KPI

See result as picture

panwipa2528
New Contributor III

Re: Use Pivot table Count Sale who can reach KPI

@Sunny Talwar Need your help.

Tags (1)
Partner
Partner

Re: Use Pivot table Count Sale who can reach KPI

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