Combining two dimension

Mon, 28 Jan 2013 16:42:40 GMT

Hi everyone,

Would anyone be able to help me to simply the following, they are in two dimesnions in the same table and I would like to know if there are more efficent to get the same results? So far they do work but take some time to load the table.

=IF(call_sign like 'CF*' or
call_sign like 'SF*' or
call_sign like 'NF*' or
call_sign like '*AED*' or
call_sign like 'DEFIB*' or
ISNULL(time_on_scene) ,NULL(), call_sign)

=IF
(BatchImages.imageStatusDetail like 'Validated' and
(Master.ChiefComplaint like '*deceased*' OR
Master.ChiefComplaint like '*cardiac arrest*' or
Master.CardArrest='1' or
Master.ROLE='1')
,IncidentNumber,NULL())

Thank you in advance for any tips.

Re: Combining two dimension

alexandros17 — Mon, 28 Jan 2013 16:47:07 GMT

there are two choices:

1) move the conditions in expressions using set analysis

2) when you load data use an additional field as a flag that satisfy all the conditions, then use that field directly in the dimension (as you do now) or use it in expression with set analysis.

Hope it helps

Alessandro

topic Re: Combining two dimension in QlikView

Combining two dimension

Re: Combining two dimension