Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

set analysis

hope someone can help me

have to create a pie chart with following expression :

Have following field names :

ShfitContractMch_codeWork_Type_ID
S0ANTWERPNAT_TROPERLO
S1BRUSSELSNAT_WGOPERLO
S1ANTWERPSH01234OPERLA
S2BRUSSELSNAT_WGOPERLA

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

1 Solution

Accepted Solutions
Not applicable

Re: set analysis

oke its working changed shfit into Std_job_id

Tks for yr help

4 Replies
Not applicable

Re: set analysis

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

Not applicable

Re: set analysis

Hey

Tks for your reply

Shfit is red underline and getting no result

Not applicable

Re: set analysis

oke its working changed shfit into Std_job_id

Tks for yr help

Not applicable

Re: set analysis

great, happy to help!

Community Browser