Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Contributor III
Contributor III

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

give me you expression

Channa
Highlighted
Contributor III
Contributor III

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

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

 

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

Channa
Highlighted
Contributor III
Contributor III

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
Highlighted
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
Highlighted
Contributor III
Contributor III

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 **
Highlighted
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