topic Re: Trying to evaluate set analysis for range but only takes current month. in QlikView

Trying to evaluate set analysis for range but only takes current month.

Mon, 15 Dec 2014 05:24:21 GMT

Dear Experts,

Help with expression where v_FTM_FIRSTDATE=01/04/2014 and v_FTM_DATE=current month date. But still gives result for current month instead of whole range.

=sum({<PMCO_WERKS= {$(vWERKS)} >}{<ZDATE = {'>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)'}>}{<PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

Re: Trying to evaluate set analysis for range but only takes current month.

rajeshvaswani77 — Mon, 15 Dec 2014 05:31:54 GMT

Hi,

Can you remove the single quotes in the ZDATE?

thanks,

Rajesh Vaswani

Re: Trying to evaluate set analysis for range but only takes current month.

ecolomer — Mon, 15 Dec 2014 05:39:58 GMT

try this:

=Sum({<PMCO_WERKS= {$(vWERKS)} >}{<ZDATE = {>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)}>}{<PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

Re: Trying to evaluate set analysis for range but only takes current month.

Mon, 15 Dec 2014 05:45:46 GMT

Thanks Enrique

but expression is showing error. Not working.

Regards

Ashif

Re: Trying to evaluate set analysis for range but only takes current month.

rajeshvaswani77 — Mon, 15 Dec 2014 05:49:29 GMT

Hi,

Please check this, the flower brackets seem to be not placed correctly.

=sum({<PMCO_WERKS= {$(vWERKS)},ZDATE = {>=$(v_FTM_FIRSTDATE)<=$(v_FTM_DATE)},PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

thanks,

Rajesh Vaswani

Re: Trying to evaluate set analysis for range but only takes current month.

jagan — Mon, 15 Dec 2014 05:55:08 GMT

HI,

Try like this

v_FTM_FIRSTDATE= MakeDate(2014, 4, 1)

v_FTM_DATE= Today()

=sum({<PMCO_WERKS= {$(vWERKS)} , ZDATE = {'>=$(=v_FTM_FIRSTDATE)<=$(=v_FTM_DATE)'}, PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

Also make sure that v_FTM_DATE and ZDATE values are in the same format.

Hope this helps you.

Regards,

Jagan.

Re: Trying to evaluate set analysis for range but only takes current month.

Mon, 15 Dec 2014 05:55:39 GMT

Thanks Rajesh,

Just check the snap. If you could help me out.

Regards

Ashif

Re: Trying to evaluate set analysis for range but only takes current month.

rajeshvaswani77 — Mon, 15 Dec 2014 06:01:58 GMT

Can you check if PMCO.ACPOS is a valid field name? You can for now remove that, as well please check if PMCO.AMOUNT is a valid field name.

Thanks,

Rajesh Vaswani

Re: Trying to evaluate set analysis for range but only takes current month.

its_anandrjs — Mon, 15 Dec 2014 06:07:02 GMT

It seems your expression is correct only introduce this in the expression

ZDATE = { ">=$(=v_FTM_FIRSTDATE) <=$(=v_FTM_DATE)" }

Also cehck the fields name weather it should be PMCA_ACPOS={'400'} AND PMCO_AMOUNT

Regards

Anand

Re: Trying to evaluate set analysis for range but only takes current month.

Mon, 15 Dec 2014 07:08:08 GMT

=sum({<PMCO_WERKS= {$(vWERKS)} , ZDATE = {'>=$(=v_FTM_FIRSTDATE)<=$(=v_FTM_DATE)'}, PMCO.ACPOS={'400'}>} PMCO.AMOUNT)/amt

this should work..

thanks

sudhanshu shrivas