Skip to Content

Create Y/N Variable Flag

Experts,

I have need to create a Variable that returns either Y or N so it can used as a Flag to turn on/off things using Input Control. The problem this is variable in NOT tied to any Objects in the Data Provider, it needs to be self stained. Also like creating your on own data values for a table.

Any suggestion,

Ajay

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jun 10, 2015 at 04:10 PM

    1. Create a variable: Flag ="Y"

    2. Create a radio button input control on [Flag].

    3. In custom list of values, add Y from the list and manually add N.

    4. Uncheck Allow selection of all values.

    5. Select a default value as Y.

    6. Test.

    Add a comment
    10|10000 characters needed characters exceeded

    • Arijit,

      I am already using this work around to do partial work, I want something that actually show TWO records. I want to user the TWO records to do more extensive show/hide of Dimensions, Sections, change fonts and others customization based on the values.

      Thanks Kindly,

      Ajay

  • Posted on Jun 11, 2015 at 07:47 AM

    Ajay, Can you brief your requirement with an example ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 16, 2015 at 05:28 PM

    Ajay,

    see if below meets your requirement.

    1. Create one measure variable with empty value.

    2. On input control, select check box and assign custom values as "Y" and "N" or as you want.

    3. By default, all values will be selected at first time.

    Thanks

    Vijai Muniraj


    1.PNG (13.0 kB)
    4.PNG (34.2 kB)
    5.PNG (5.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2015 at 09:41 AM

    May I ask you what's the purpose of it ?

    Regards,

    Rogerio

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ajay,

      As Harshad and Vijay Muniraj said create A dummy variable, this would not be related to your data, but

      based on the selection of input control you can write a logic to what you want show, even in table or

      chart properties also you can use show/hide option as requested. With current features of webi I hope

      you can achieve.

      Please post your problem with screen shots it would be easier to understand your scenario.

      Regards,

      Sampath Kumar G

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2016 at 06:08 PM

    Ajay,

    I know that's an old question, but maybe this could helps another users.

    Create a WebI Variable with this formula:

    =If (RowIndex()=1) Then "Y" ElseIf (RowIndex()=2) Then "N"

    This formula allow users to create any custom values and use them on reports. Just replace the =? values for the array sequence and the "" for custom value.


    Regards.

    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.