Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jayati_shrivast
Contributor III
Contributor III

hiding greyed value from filter pane

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

 

10 Replies
Channa
Specialist III
Specialist III

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

Channa
jayati_shrivast
Contributor III
Contributor III
Author

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
Specialist III
Specialist III

give me you expression

Channa
jayati_shrivast
Contributor III
Contributor III
Author

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

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

 

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

Channa
jayati_shrivast
Contributor III
Contributor III
Author

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
Specialist III
Specialist III

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

Channa
jayati_shrivast
Contributor III
Contributor III
Author

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
Specialist III
Specialist III

both should bring same value share ur sample  data

when condition satisfies it bring only those dates into ur listbox

Channa