topic Re: where condition in a variable in QlikView

where condition in a variable

ali_hijazi — Wed, 08 Apr 2015 08:17:26 GMT

Hello

got around 20 expressions that share the same where condition

STEP_DURATION_MIN={"*"}

,RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

is there a way that allows me to put the above in one variable and keep the expressions running?

Please advise

Re: where condition in a variable

jagan — Wed, 08 Apr 2015 08:29:18 GMT

HI,

Try like this

vCommonStatement = {<STEP_DURATION_MIN={"*"},RECORD_TYPE={'duration'},Year=,Month=, CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"} >}

=Sum($(=vCommonStatement ) MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: where condition in a variable

ali_hijazi — Wed, 08 Apr 2015 08:35:24 GMT

nop it didn't work

Re: where condition in a variable

sunilkumarqv — Wed, 08 Apr 2015 08:37:19 GMT

Hi Ali,

you can put this in variable

set vVariable ='

STEP_DURATION_MIN={"*"}

,RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

and then you can use similar variable in expression sum({$(=vVariable)})

Re: where condition in a variable

pokassov — Wed, 08 Apr 2015 08:38:34 GMT

Hi!

vTest

STEP_DURATION_MIN={"*"}

,RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(=date(vFromDate)) <=$(=date(vToDate))"}

sum({$ $(vTest)} Qty)

Re: where condition in a variable

ali_hijazi — Wed, 08 Apr 2015 08:44:13 GMT

didn't work

Re: where condition in a variable

ali_hijazi — Wed, 08 Apr 2015 08:45:21 GMT

didn't work

Re: where condition in a variable

pokassov — Wed, 08 Apr 2015 08:57:20 GMT

Does it work?

sum({$

STEP_DURATION_MIN={"*"}

,RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(=date(vFromDate)) <=$(=date(vToDate))"}

} your_field_for_um)

Re: where condition in a variable

ali_hijazi — Wed, 08 Apr 2015 09:01:31 GMT

yes of course

Re: where condition in a variable

jagan — Wed, 08 Apr 2015 09:04:39 GMT

Hi,

Is this statement working

Sum({<

STEP_DURATION_MIN={"*"}

,RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

>} SomeMeasureName

)

If this works then this should definitely works

vCommonStatement = {<STEP_DURATION_MIN={"*"},RECORD_TYPE={'duration'},Year=,Month=, CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"} >}

=Sum($(=vCommonStatement ) MeasureName)

If possible attach the sample file.

Regards,

jagan.

Re: where condition in a variable

simsondevadoss — Wed, 08 Apr 2015 09:06:36 GMT

You can use SET vTest='

<STEP_DURATION_MIN={"*"},RECORD_TYPE={'duration'}

,Year=

,Month=

,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}>' in the backend.

use the variable in the front end

Re: where condition in a variable

jagan — Wed, 08 Apr 2015 09:13:56 GMT

Hi,

Dont give = in variable declaration.

Regards,

Jagan.