topic Charts. in QlikView

Charts.

Wed, 01 Jul 2015 10:50:04 GMT

I have a source table with three columns.

Claim Number, Pred_Status and BR_Status.

I need to create a Bar chart. Where it should show the Count of FRAUD alone for "BR_STATUS" and "PRED_STATUS".

Please find the Data attached.

Gysbert_Wassenaar — Wed, 01 Jul 2015 11:03:42 GMT

Use these expressions:

count({<predicted_fraud_status={'Fraud'}>}[Claim Number])

count({<BR_status={'Fraud'}>}[Claim Number])

krishna20 — Wed, 01 Jul 2015 11:43:27 GMT

Is this your expected output?

=count({<BR_status={'Fraud'}>}[Claim Number])

=count({<predicted_fraud_status={'Fraud'}>}[Claim Number])

Wed, 01 Jul 2015 12:00:08 GMT

Thanks Krishna. Its working

krishna20 — Wed, 01 Jul 2015 12:37:29 GMT

You are always welcome Praveen. Please close the thread if you are satisfied with our answers.