set analysis

[#1]

hope someone can help me

have to create a pie chart with following expression :

Have following field names :

Shfit	Contract	Mch_code	Work_Type_ID
S0	ANTWERP	NAT_TR	OPERLO
S1	BRUSSELS	NAT_WG	OPERLO
S1	ANTWERP	SH01234	OPERLA
S2	BRUSSELS	NAT_WG	OPERLA

Need to create a pie chart for only the items with Mch_code SH* and counting result SH01234 1

Need to create a pie chart for only the items with Mch_code NAT* and counting result NAT_TR 1 & NAT_WG 2

Can someone help me with creating the set analysis ?

Tks for yr help

Rudi

[#2]

hello

try this one for the first one  count({$<Mch_code= {"SH*"}>}Shfit) and this for the second chart

count({$<Mch_code= {"NAT*"}>}Shfit). and let me know

[#3]

Hey

Tks for your reply

Shfit is red underline and getting no result

[#4 · Accepted solution]

oke its working changed shfit into Std_job_id

Tks for yr help

[#5]

great, happy to help!