topic creating button based on multiple conditions in QlikView

creating button based on multiple conditions

Fri, 23 Jul 2010 15:56:02 GMT

See the included statement:

How can I exclude the result from below statement

(ACCOUNT='LB2675-92', 'DE VAT LB2675-92') as DE_VAT_in_MFL

into the below string of text

(IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],

I tried already the following but it did not work:

IF(ACCOUNT<> 'LB2675-92' and IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],

IF(ISNULL(DE_VAT_in_MFL) and IC_Purchases_MFL = 'EU Vendor' and COMPANY_CODE = 'LB' ,'IC Purchase MFL') as [IC Purchase MFL],

Your support is appreciated as I already lost a lott of time in this issue.

Regards,

Patrick

creating button based on multiple conditions

Fri, 23 Jul 2010 23:20:16 GMT

Hi Patrick,

I think you're going to have to explain your issue a bit better before we can offer any assistance. I (for one) have no idea what you're trying to do, or what the issue is.

creating button based on multiple conditions

llauses243 — Mon, 26 Jul 2010 11:17:14 GMT

For minispecifications i use booakmarks

For easy maintenance forall bookmarks i use particular tab, hide for end users

The each time to filter i execute bookmarks vía button or macro