topic Re: set analysis and expression in QlikView

set analysis and expression

krishna20 — Tue, 01 Jul 2014 09:25:49 GMT

Hi friends

I need to include set analysis inside the expression please any one can help me out.

my expression is =SUM({<CE_CLOSE_YN={'1'},{<CE_CLOSE_DT<TODAY()>}>}CE_AMT_LC1=0) and in else condition CE_CLOSE_YN>='1' and CE_CLOSE_DT>Today(),SUm(CE_AMT_LC_1)

Regards

kalyan

Re: set analysis and expression

sasikanth — Tue, 01 Jul 2014 09:34:13 GMT

try some thing like this

if(sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)='0',

sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT= {">(=Today())"}>}CE_AMT_LC_1))

Re: set analysis and expression

krishna20 — Tue, 01 Jul 2014 09:39:04 GMT

Hi Sasi

The expression is raising error .not at all taking from after closing set analysis.

Re: set analysis and expression

sasikanth — Tue, 01 Jul 2014 09:45:27 GMT

Try

IF(isNull(sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)),

sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT={">(=Today())"}>}CE_AMT_LC_1))

Re: set analysis and expression

Anonymous — Tue, 01 Jul 2014 09:56:01 GMT

Hi,

Try below,

Sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)+

Sum({<CE_CLOSE_YN-={'1'},CE_CLOSE_DT={">=(=TODAY())"}>}CE_AMT_LC_1)

Re: set analysis and expression

Tue, 01 Jul 2014 10:14:36 GMT

try like this

Create variable like

Vsum=sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={'<$(=Date(today(),'DD/MM/YYYY'))'}>}CE_AMT_LC1)

Vsum1=sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT= {">(=date(Today(),'DD/MM/YYYY'))"}>}CE_AMT_LC_1)

then try to build the expression like

=if(Vsum='0',Vsum1)

hope this will helps you