Qlik sense filter pane

[firoz24]

Hi Guys,

I want to set the expression in filter pane 

=monthend ([Inspection Date 1]),([STATION]={'BACK DOOR GLASS'})

I have a field called station from there it should take monthend date 

I am trying to create a bookmark so it will be bookmark automatically after each day as the data gets update.

[Rohan]

Hi Firoz,

You can't apply Set expressions to Dimensions unless you use Aggr(). You can instead simply use If condition in your Filter pane Dimension. Something like :

If ([STATION]='BACK DOOR GLASS',monthend ([Inspection Date 1]),null())

Regards,

Rohan.

[firoz24]

I got 4.5333 but not received date in filter pane 

when I select the number it didnt get filtered

[Nicolae_Alecu]

Hello,

@Rohan solution should work just fine.

Also you can apply this into a bookmark:

Best Regards,