topic Re: OR mode for calendar slider in QlikView

OR mode for calendar slider

Tue, 25 Feb 2014 08:14:58 GMT

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

Re: OR mode for calendar slider

preminqlik — Tue, 25 Feb 2014 08:40:47 GMT

Hi there once try this

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

Re: OR mode for calendar slider

Anonymous — Tue, 25 Feb 2014 16:44:35 GMT

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

Re: OR mode for calendar slider

Wed, 26 Feb 2014 08:10:29 GMT

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 ,