topic Re: Limit values in a listbox in QlikView

Limit values in a listbox

Tue, 15 Nov 2016 13:10:25 GMT

Hi Everyone,

I would like to restrict listbox values based on conditions for more than one field.

Please help.

Thanks

Re: Limit values in a listbox

sunny_talwar — Tue, 15 Nov 2016 13:11:38 GMT

What are the conditions? May be use an if statement....

Re: Limit values in a listbox

its_anandrjs — Tue, 15 Nov 2016 13:19:41 GMT

Did you mean the condition is based onthe 2 or 3 fields then you can try this ways on the list box with if condition

Ex:-

=If( Product = 'Product A' and Year = 2016, Category)

Or please elaborate more on the requirement

Regards

Anand

Re: Limit values in a listbox

Tue, 15 Nov 2016 13:22:12 GMT

I already have this condition:

=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',

'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)

But I also want to add another one : Source_={'Business Bank'}

Re: Limit values in a listbox

rubenmarin — Tue, 15 Nov 2016 13:40:29 GMT

Hi Moses, the code between '{<' and '>}' is called "set analysis", it's a way to set filters to a field, in that part there are fields separated with commas and the values assigned to each field betwee '{' and '}' (many values are checked as an OR, so the field can have any of those values), so you just add a new field:

'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}, Source_={'Business Bank'}>}Campaign),Campaign)

The set analysis filters 2 fields: Campaign and Source_

Re: Limit values in a listbox

Tue, 15 Nov 2016 13:40:58 GMT

I already have this condition:

'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',

'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)

But I also want to add another one : Source_={'Business Bank'}