Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

categorize the values

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

8 Replies
ggallina
Contributor III

Re: categorize the values

Hi,

can you post a QVW file with test data?

Regards.

qlikmsg4u
Valued Contributor

Re: categorize the values

Hi Gabriel,

Please post some sample data

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

Not applicable

Re: categorize the values

Use calculated dimension as

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

Re: categorize the values

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.


talk is cheap, supply exceeds demand

Re: categorize the values

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



Re: categorize the values

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

Not applicable

Re: categorize the values

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


Re: categorize the values

one example:

QlikCommunity_Thread_168747_Pic1.JPG

QlikCommunity_Thread_168747_Pic2.JPG

hope this helps

regards

Marco

Community Browser