Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

creating button based on multiple conditions

See the included statement:

How can I exclude the result from below statement

if

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

into the below string of text



IF

(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



2 Replies
Not applicable
Author

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.

llauses243
Creator III
Creator III

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