hiding greyed value from filter pane

[jayati_shrivast]

Hi All,

I have a Date field in the format 'DD-MM-YYYY hh:mm:ss'. I have used this DATE field in three filters as YEAR, MONTH AND DATE.

For YEAR I have applied the expression as  year(Date field)

For MONTH I have applied the expression as MONTH(AGGR(Date field,Date field)) in order to remove the grey color values.

for DATE I have applied expression as =DATE(FLOOR(Date field),'DD-MMM-YYYY')

I want is to hide the greyed out values totally based on selection in previous filter box.

example: Current scenerio

The Filter Value selected by User is depicted in BOLD

YEAR                   MONTH                    DATE

2019                    JAN                             1 JAN 2019   (coming as white color)

2018                     FEB                            2 JAN 2019 and so on till 31 jan 2019(coming as light grey color)

                                                                      1 feb 2019 (coming as dark grey color)

                                                                       2feb 2019 ... and so on till     28 feb 2019(coming as dark grey color)

    If I select JAN as month for year 2019 I should get only JAN dates but the date filter is also displaying feb dates as well in dark grey color. Also when I select JAN as month, feb month is getting disappear, it should come in light grey color.

My main concern is to remove the dark grey color values

what changes I should apply in the filter expression in order to hide the dark  grey color values based on selection in previous filter pane.

Kindly help.

Thanks

[Channa]

HI 

have similar case

when i select Product i need to see only related SubProducts

i did this

in subProducts i use like below

variable VProduct=product

IF(Product =vproduct,SubProducts)

you can something similar

[jayati_shrivast]

thanks for the help. I Tried this, but its not working in my case. Is there any other way by which I can implement?

[Channa]

give me you expression

[jayati_shrivast]

if(Date Field = Vmonth, DATE(Date Field))
under variable the expression is as follows Vmonth = month(Date Field)

[Channa]

if(Month(Date Field) = Vmonth, DATE(Date Field))

condition will fail if we dont use Month(date field)

[jayati_shrivast]

I applied like this
if(Month(Date Field) = Vmonth, DATE(Date Field,'DD-MMM-YYYY'))
But now no values are coming, in the date filter

[Channa]

you need to select month

and see

=Month(Date Field)--keep it in one text box

and =Vmonth in another text box see both are same or not

[jayati_shrivast]

Even after selecting month , I am not getting the values in the date filter.
also in the text box, in both the text box the values are coming same but in different format. its coming as **

[Channa]

both should bring same value share ur sample  data

when condition satisfies it bring only those dates into ur listbox