Skip to Content
author's profile photo Former Member
Former Member

Input parameter

Dear all,

In hana studio, I build two input parameters:"Year" and "Month"

And I put the two parameters as filters in calculation view,

There are two cases,

one case, I want to view the data on date 2016-03, I just input year(2016) and month(03) in the filter, the result is ok

second case, I want to view the whole year data, such as year 2016, I just input year(2016) in the filter, do nothing in the filter month, there is nothing

How to solve the problem, if I input nothing in the filter, the database returns the all data

Many thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jul 12, 2016 at 01:25 PM

    Hi,

    Please use this Filter Expression for Month:

    in("MONTH", '$$Month$$') OR match("MONTH", '*$$Month$$*')

    In Input Parameter Prompt, Enter the value as "*"

    It will retrieve all the months.

    Regards,

    Muthuram

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 16, 2016 at 10:13 AM

    Hi Wang,

    Create two calculated columns based on Year and Month.

    Use variables on top of these instead of input parameters.

    Here , user can give year and can ignore month, or user can give any month and its year.

    If no input is given then it will bring all data .

    Thanks,

    Ramesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2016 at 12:50 PM

    Hi, I think MATCH key wont work.

    Please use this Filter Expression for Month:

    (in("MONTH", $$Month$$) or in ( ($$Month$$,'*'))

    In Input Parameter Prompt, Enter the default value as "*"

    It will display all the data related months.

    Regards,

    Kamruz

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.