Create a specific time filter

[H_STROLLE]

Hello together,

I'm total new in Qlik Sense and have a Question:
I've a time field in the following Format:  DD.MM.YY and want to create a filter in my Dashboard in this Format:
MM.YY or MM.YYYY (that doesn't matter).

How can I create such a field / filter ? I've searched the functions but couldn't find a possibility to Change the Format.

Thanks for your help.

[marcus_sommer]

If your field is really a date you could apply: date(YourField, 'MM.YYYY'). If it's a timestamp you need to remove the time-part like: date(floor(YourField), 'MM.YYYY').

But this is just a formatting and wouldn't change the values beneath the displayed value. If you want this you may use:

dual(date(YourField, 'MM.YYYY'), year(YourField) * 100 + month(YourField))

- Marcus

[rwunderlich]

I would go with 

Date(MonthStart(yourField), 'MM.YYYY') 

rather than Dual().

-Rob