Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Charts.

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.

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use these expressions:

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

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


talk is cheap, supply exceeds demand
krishna20
Specialist II
Specialist II

Is this your expected output?

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

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

Comm.png

Not applicable
Author

Thanks Krishna. Its working

krishna20
Specialist II
Specialist II

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