topic list box data in QlikView

list box data

Fri, 10 Jan 2014 11:38:55 GMT

I have a data set in a table that is created and consists of around 30k unique entries.

However in my actual data set only about 10% of these have a value attached, ie you could think of this as being all customers ever set up but within the period only 10% have completed a transaction.

In my list box I only want only the records that have a transaction to be shown so as to reduce the “clutter”.

The formula below appears to work as a much reduced list of records is brought through into the list box.

However the issue i have is that when one is selected the rest disappear completely out of the list box unlike with the standard list box where they are greyed out but stay in the box.

how can i edit my formula/settings so that the other options stay in the box and appear greyed out as per the standard formats of a list box?

Aggr(If(

(

fabs(ROUND(Sum(COST)))+fabs(round(sum(revenue)))

) <>0, [Driver Type]),[Driver Type]

)

Re: list box data

salto — Fri, 10 Jan 2014 12:15:08 GMT

Hi Jono,

I am fraid I do not understand completely your question... If you only want the customers that have completed a transaction, I would left join the transactions data with the customers. The resultant table of the left join would only have the customers with transactions.

Hope this helps!

Re: list box data

Michiel_QV_Fan — Fri, 10 Jan 2014 12:25:37 GMT

I agree with Salto.

However, you could also create a straight table with the customer as dimension and the transaction revenue as expression.

suppress zero values on the dimension and add a set analysis in the expression to show all values greater than 0.

Not a really nice solution, more a work around.

Re: list box data

bbi_mba_76 — Fri, 10 Jan 2014 12:27:16 GMT

Hi,

if I understand well you have to add a set analysis to ignore the selection.

So sum({1} ... if you want to ignore all selections, whereas you have to ignore only Field1

sum({<Field1=>} ...