Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Hi,

can you post a QVW file with test data?

Regards.

qlikmsg4u
Specialist
Specialist

Hi Gabriel,

Please post some sample data

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

Not applicable
Author

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.


talk is cheap, supply exceeds demand
MarcoWedel

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



MarcoWedel

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

Not applicable
Author

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:

QlikCommunity_Thread_168747_Pic1.JPG

QlikCommunity_Thread_168747_Pic2.JPG

hope this helps

regards

Marco