categorize the values

[#1]

hello all,

i have a to do a graph to dsiplay the values of the field : report_role. the field has three values :Voluntary Party, Reporting Party, nonreportingparty. I have to do just 2 categories for the values : Voluntary Party (Voluntary Party + nonreportingparty)  and Reporting Party.

can someone give me the main steps to di this in the designer ?

thnaks in advance

[Anonymous]

Hi,

can you post a QVW file with test data?

Regards.

[qlikmsg4u]

Hi Gabriel,

Please post some sample data

https://community.qlik.com/docs/DOC-1290

[#4]

Use calculated dimension as

If(Match(report_role,'Voluntary Party','nonreportingparty') , 'Voluntary Party', Reporting Party)

[Gysbert_Wassenaar]

Create two set analysis expressions, one for each category. If your current expression is sum(TransactionAmount) then create two expressions like these:

Voluntary Party: sum({<report_role={'Voluntary Party','nonreportingparty'}>}TransactionAmount)

Reporting Party: sum({<report_role={'Reporting Party'}>}TransactionAmount)

Make sure to use the exact case sensitive field names and values of your document. Don't blindly copy my example expressions.

[MarcoWedel]

If(Match(report_role,'Voluntary Party','nonreportingparty') , 'Voluntary Party', 'Reporting Party')

[MarcoWedel]

If(report_role = 'nonreportingparty', 'Voluntary Party', report_role)

[#8]

Hi

Please see below  my comments and accordingly change the syntax and your case sensitive fields.

sum(TransactionAmount) then create two expressions like these:

Voluntary Party: sum({<report_role={'Voluntary Party','nonreportingparty'}>}TransactionAmount)

Reporting Party: sum({<report_role={'Reporting Party'}>}TransactionAmount)

Thanks

[MarcoWedel]

one example:

hope this helps

regards

Marco