topic Re: if to set analysis in QlikView

if to set analysis

Wed, 02 Jul 2014 08:03:32 GMT

Hello,

i wont to convert this expression :

if(dim_a='yes' or dim_b='yes', sum(CA))

to set analysis

best regards

MK_QSL — Wed, 02 Jul 2014 08:06:51 GMT

SUM({<dima_a = {'yes'}>}CA) +

SUM({<dima_b = {'yes'}>}CA)

Wed, 02 Jul 2014 08:09:22 GMT

there is no way to do it in the same expression ?

ashfaq_haseeb — Wed, 02 Jul 2014 08:11:03 GMT

Hi,

Try below

SUM({<dima_a = {'yes'},dima_b = {'yes'}>}CA)

Regards

ASHFAQ

Wed, 02 Jul 2014 08:13:27 GMT

=Sum({<dim_a={'A'}>+<dim_b={'B'}>} CA)

its_anandrjs — Wed, 02 Jul 2014 08:14:01 GMT

Write like

Sum( {<dim_a = {'yes'}, dim_b = {'yes'}>} CA)

Wed, 02 Jul 2014 08:15:50 GMT

SUM({<dima_a = {'yes'}>}CA) + SUM({<dima_b = {'yes'}>}CA)

VishalWaghole — Wed, 02 Jul 2014 09:19:44 GMT

Sum({<dim_a = {'yes'}> + <dim_b = {'yes'}>} CA)