Set Analysis with Variable

[Anonymous]

Hi,

I have created a variable for date selection as below:

vPeriod = if(GetSelectedCount(Period) > 0 , GetFieldSelections(Period), '16/06/1980')
//if(GetSelectedCount(Period) > 0 , Concat(DISTINCT Chr(39) & Period & Chr(39), ', '), Chr(39) & '31/12/2003' & Chr(39))

And using the below expression

=Only({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriod)"}>} N1)

But when I select other selection then my Date variable does not work.

Can you please advise me related to this?

Kind regards,

Farrukh

[Anonymous]

Thanks a mil sunny for highlighting the missing date on specific dates..

Is there any possibility that If I select Draw then from Period field can be Hide if there is no data and can only display to select the dates where the data is available.

Kind regards,

Farrukh

[sunny_talwar · Accepted solution]

You can hide or you can select State as Auto Ascending

[Anonymous]

Thanks a mil Sunny.

[Anonymous]

Hi Youssef,

AR_ID is not a key value, the key Value is "CREATED" field. which is linked to master calendar.

Farrukh