Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

How to make the bar display as 2 For reject code = 124 ?

Hi All

I want to plot a chart that display the Qty of reject by reject code, I don't have the Qty value , i only have the reject code . May i know how to count number of reject code and display on the bar chart ?

Paul

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: How to make the bar display as 2 For reject code = 124 ?

Hi Paul,

try

count(Aggr(NODISTINCT kode_reject,line_id))

Regards,

Antonio

5 Replies
antoniotiman
Honored Contributor III

Re: How to make the bar display as 2 For reject code = 124 ?

Hi Paul,

try

count(Aggr(NODISTINCT kode_reject,line_id))

Regards,

Antonio

paulyeo11
Valued Contributor II

Re: How to make the bar display as 2 For reject code = 124 ?

Thank , it work fine.

paulyeo11
Valued Contributor II

Re: How to make the bar display as 2 For reject code = 124 ?

Hi Sir

I want to count total number of reject by kode_reject , meaning I will place kode_reject at dimension .

Paul

Sent from my iPhone

antoniotiman
Honored Contributor III

Re: How to make the bar display as 2 For reject code = 124 ?

Try aggr() with date_time instead of line_id

paulyeo11
Valued Contributor II

Re: How to make the bar display as 2 For reject code = 124 ?

Hi Antonio

Thank you vey much , i manage to create all the chart i need.

Paul

Community Browser