Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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