Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis OR syntax

I am trying to add an additional parameter to a set analysis expression -

where client leave date = 01/01/1900 OR client leave date >= a loaded variable vDateStartWeek

Trying variances of the below but I cannot get it display correctly?

[Client leaveDate]  = {01/01/1900}> + <[Client leaveDate] = {">=$(=Date(vDateStartWeek))"}>},

Tags (2)
1 Solution

Accepted Solutions

Re: Set Analysis OR syntax

Try {<[Client leaveDate]  = {'01/01/1900', '>=$(=Date($(vDateStartWeek)))'}>}


talk is cheap, supply exceeds demand
3 Replies
giakoum
Honored Contributor II

Re: Set Analysis OR syntax

[Client leaveDate]  = {01/01/1900} + {">=$(=Date(vDateStartWeek))"}>}


Re: Set Analysis OR syntax

Try {<[Client leaveDate]  = {'01/01/1900', '>=$(=Date($(vDateStartWeek)))'}>}


talk is cheap, supply exceeds demand
Not applicable

Re: Set Analysis OR syntax

Thank you, works well.

Community Browser