topic Re: set analysis with expresison in QlikView

set analysis with expresison

souadouert — Mon, 11 Jun 2018 08:33:44 GMT

how two covert this expresion to set analysis expression

sum(if( mid($(DATE),3,2) = right(DATE_PRODUCTION,2) ,amout))

Re: set analysis with expresison

sumeet-vaidya — Mon, 11 Jun 2018 08:49:53 GMT

Hi Souad,

Create a Column in your script for Right(DATE_PRODUCTION,2) AS DATE_PRODUCTION_NEW.

And use below Expression.

Sum({<DATE_PRODUCTION_NEW = {"$(=Mid(DATE),3,2)"} >} Amount)

Regards

Sumeet

Re: set analysis with expresison

souadouert — Mon, 11 Jun 2018 08:55:17 GMT

i am not allow to modify the script

Re: set analysis with expresison

tresB — Mon, 11 Jun 2018 09:17:08 GMT

Is DATE in sum(if( mid($(DATE),3,2).... a variable?

Re: set analysis with expresison

dwforest — Mon, 11 Jun 2018 17:54:07 GMT

if the IF statement is working, not necessarily a better idea to use SET Expression.

Because the fields do not contain the exact matching you are after, it gets a bit more complex to do a Set Expression since left side must be a field only.

In order to do this, there must be a primary key,e.g. ID_FIELD, in your data set

Sum({<ID_FIELD= {"=$(=Mid(DATE),3,2) )= $(=right(DATE_PRODUCTION,2))"} >} Amount)

Re: set analysis with expresison

vishsaggi — Mon, 11 Jun 2018 18:58:47 GMT

May be try this?

= sum({< Amount = {"=if( mid($(DATE),3,2) = right(DATE_PRODUCTION,2) ,amount)"} >} Amount)