topic Re: charts calculations in QlikView

charts calculations

prabhas277 — Tue, 28 Jul 2015 18:50:02 GMT

Hi experts,

is it possible multiple conditions in one if conduction?

ex: I have one bar chart in that layout tab i will write if(product='apple',1,0) it means product=apple then the chart will visible now my question is if(product='apple''banana',1,0) is it possible?

Re: charts calculations

Kushal_Chawda — Tue, 28 Jul 2015 18:52:33 GMT

yes, try this

=if(match(lower(Product),'apple','banana'),1,0)

Re: charts calculations

maxgro — Tue, 28 Jul 2015 18:58:42 GMT

=wildmatch(product, 'apple', 'banana')

Re: charts calculations

MarcoWedel — Tue, 28 Jul 2015 20:24:50 GMT

if(product='apple' or product='banana',1,0)

hope this helps

regards

Marco

Re: charts calculations

MarcoWedel — Tue, 28 Jul 2015 20:25:42 GMT

or simply

product='apple' or product='banana'

regards

Marco

Re: charts calculations

MarcoWedel — Tue, 28 Jul 2015 20:27:45 GMT

=mixmatch(product, 'apple', 'banana')