topic Re: wildmatch from GetFieldSelections 2 conditions in QlikView

wildmatch from GetFieldSelections 2 conditions

Anonymous — Fri, 19 Sep 2014 07:55:07 GMT

hi Guys

i have the below statement i use to conditionally enable an expression in a chart and this works perfect

=Alt( WildMatch ( GetFieldSelections(%ExpressionName, '|'), '*Total Billed*' ) , 0 )

the user selects Total Billed from the %ExpressionName list box the the expression Total billed is enabled

fair enough

now my issue is :-

i want to add a second condition in the same statement like

a user enables the Total billed expression after

1. selecting the Total billed in %expressionName list box

2 .also select (for example) billing in the %ChartName ListBox

in English i would write it as

Enable Expression 'Total Billed' when 'Total Billed' is Selected in %ExpressionName and 'Billing' is selected in %ChartName

hope i make sense here

thanx in advance

jagan — Fri, 19 Sep 2014 08:01:11 GMT

Hi,

Try like this

=WildMatch ( GetFieldSelections(%ExpressionName, '|'), '*Total Billed*' ) AND

WildMatch ( GetFieldSelections(%ChartName, '|'), '*Billing*' )

Hope this helps you.

Regards,

Jagan.

Anonymous — Fri, 19 Sep 2014 08:29:31 GMT

Hi Jagan

Thanx so far your solution seems working thank you very much i will continue testing with it because i have a number of expression