topic Create a specific time filter in App Development

Create a specific time filter

H_STROLLE — Tue, 13 Apr 2021 13:35:24 GMT

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.

Re: Create a specific time filter

marcus_sommer — Tue, 13 Apr 2021 14:35:53 GMT

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

Re: Create a specific time filter

rwunderlich — Tue, 13 Apr 2021 15:24:12 GMT

I would go with

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

rather than Dual().

-Rob