Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fahuruba
Creator
Creator

wildmatch from GetFieldSelections 2 conditions

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

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


Hope this helps you.


Regards,

Jagan.

View solution in original post

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

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


Hope this helps you.


Regards,

Jagan.

View solution in original post

fahuruba
Creator
Creator
Author

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