topic Re: categorize the values in QlikView

categorize the values

Wed, 17 Jun 2015 10:29:55 GMT

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

Re: categorize the values

Anonymous — Wed, 17 Jun 2015 10:32:45 GMT

Hi,

can you post a QVW file with test data?

Regards.

Re: categorize the values

qlikmsg4u — Wed, 17 Jun 2015 10:33:02 GMT

Hi Gabriel,

Please post some sample data

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

Re: categorize the values

Wed, 17 Jun 2015 10:35:30 GMT

Use calculated dimension as

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

Re: categorize the values

Gysbert_Wassenaar — Wed, 17 Jun 2015 10:40:47 GMT

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.

Re: categorize the values

MarcoWedel — Wed, 17 Jun 2015 10:53:24 GMT

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

Re: categorize the values

MarcoWedel — Wed, 17 Jun 2015 10:55:08 GMT

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

Re: categorize the values

Wed, 17 Jun 2015 11:11:28 GMT

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

Re: categorize the values

MarcoWedel — Fri, 19 Jun 2015 21:42:53 GMT

one example:

hope this helps

regards

Marco