Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

where condition in a variable

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

I can walk on water when it freezes
11 Replies
simsondevadoss
Partner - Creator III
Partner - Creator III

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

jagan
Partner - Champion III
Partner - Champion III

Hi,

Dont give = in variable declaration.

Regards,

Jagan.