OR mode for calendar slider

[#1]

Dear Gurus,

I facing issue in OR mode for calendar slider, attached the app, where I need to get ‘T Or M Dates” when my selection is

TDate: 5-11-2012 to 30-11-2012

MDate: 1-11-2012 to 2-11-2012

I have to get OR mode and data should be for Date: 5-11-2012 to 30-11-2012 OR MDate: 1-11-2012 to 2-11-2012

[preminqlik]

Hi there once try this

='>=' & Date(vMinMDate, 'DD/MM/YYYY') &  ' or ' & '<=' & Date(vMaxMDate, 'DD/MM/YYYY')

[Anonymous]

See attached.

I added one more field, ID, unique per data row, and I"m making selection in this field rather than in TDate and MDate.  Using Toggle Select with the search string

='(' &

concat({<TDate={"$(='>=' & Date(vMinTDate, 'DD/MM/YYYY') & '<=' & Date(vMaxTDate, 'DD/MM/YYYY'))"}>

+ <MDate={"$(='>=' & Date(vMinMDate, 'DD/MM/YYYY') & '<=' & Date(vMaxMDate, 'DD/MM/YYYY'))"}>} distinct ID

, '|')

& ')'

Regards,

Michael

[#4 · Accepted solution]

Thanks a lot Prem and Michael,

Unfortunately i cannot use both the solution, However i resolved this issue with if condtion in the dimension of the chart and ticked "Suppress When Value is null"

if(
if(TDate >=vMinTDate and TDate <= vMaxTDate,1,0)+
if(MDate >=vMinMDate and MDate <= vMaxMDate,1,0) >= 1 ,

1)