Date Filter / Parameter Month Drop down

Q&A
, , , ,
1

I am trying to create two date filters -
One is a date range (this I have no issue with)
The second I want a Month view - so I want to pick a Month NAME and for it to result the full Month

the way I am doing this is using a parameter - but if I use a date field the only option I get is drop down calendar - I have tried using a “month” field - but then it the formula does not work

image
image530×262 17.3 KB

Any ideas

ifelse(
${View} = 'Month View' AND truncDate('MM',{INVOICE_DATE}) >= ${MonthViewMonth} AND {INVOICE_DATE} < addDateTime(1, 'MM', ${MonthViewMonth})
,
truncDate('MM',{INVOICE_DATE}),
${View} = 'Date Filter' AND {INVOICE_DATE} >= ${DateRangeStart} AND {INVOICE_DATE} <= ${DateRangeEnd},
{INVOICE_DATE},
NULL
)
2

Hi @emma.lancaster and welcome to the Quick Sight community!
Since QS does not provide any additional options for month parameters, I would suggest converting it to a string so that you can get a dropdown parameter. Then your ifelse statement will be a lot easier to setup with the string values.

Let me know if you have any additional questions!

1 Like
3

Hi @emma.lancaster

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @emma.lancaster

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!