topic Re: show list box field with conditional in QlikView

show list box field with conditional

stephenedberkg — Thu, 17 Sep 2015 12:38:20 GMT

my list box have the customer

i want to show the list box customer sales=0 only.

(sum({<TransactionType = {'INVOICE'}>}#InvNetSales)

- Sum({<TransactionType = {'CreditNote'}>}#InvNetSales)) = 0

the above formula is my sales i want to display the 0 sales customer only in my list box

Re: show list box field with conditional

maxgro — Thu, 17 Sep 2015 12:57:15 GMT

maybe

if(aggr(

(sum({<TransactionType = {'INVOICE'}>}#InvNetSales)- Sum({<TransactionType = {'CreditNote'}>}#InvNetSales)

Customer)=0,Customer)

Re: show list box field with conditional

stephenedberkg — Fri, 18 Sep 2015 06:36:51 GMT

maxgro

Where i want to write this formula in expression tab Definition or Conditional?

if i write in definition i get like this

if i write in conditional i get like this

Re: show list box field with conditional

maleksafa — Fri, 18 Sep 2015 06:40:51 GMT

you need to write it in the General Tab, where you select the dimensions from the list. at the end of the list there is expression, there you should input this expression

Re: show list box field with conditional

stephenedberkg — Fri, 18 Sep 2015 06:45:13 GMT

in list box general is this only..where can i write?

Re: show list box field with conditional

stephenedberkg — Fri, 18 Sep 2015 07:24:16 GMT

go to list box properties-> field-> expression (Bottom of the field) -> write formula

=if(aggr(sum(InvNetSales),CustomerShortName)=0,CustomerShortName)