topic Adding calculations to Multi Boxes for selection in QlikView

Adding calculations to Multi Boxes for selection

Wed, 14 Dec 2011 21:37:53 GMT

I have a column in a table that is calculated using the following logic:

count({$<VISIT_TYPE={'ER'}>} DISTINCT VISITNUMBER)

I want to add a selection item to my Mulit box that says:
if(count({$<VISIT_TYPE={'ER'}>} DISTINCT VISITNUMBER)>'0','Yes','No')

This will allow the user to filter on all records where the visit count is greater than 0. QV doesn't like the calculation in the Mulit box and grays out the selections.

Thanks!

Adding calculations to Multi Boxes for selection

brenner_martina — Thu, 15 Dec 2011 14:31:29 GMT

Hi, boyer,

that's right, QV does not know any selection possibility for your Yes or No. You must integrat it to your Script. Use a simple If-Then-Else-Statement, something like:

Table:

Load ...,

If(VISIT_TYPE='ER','Yes','No') As SelectionVisitType,

...

From ...;

Greetings from Munich

Martina

EVACO GmbH