8 Replies Latest reply: Jul 4, 2016 9:22 AM by Vineeth Pujari RSS

    hide and show

    naveen kumar

      Hello,

      In below straight table layout condition i am writing this

       

      =Question_Text='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'

       

       

      i am displaying Question_text values on above straight table

      so the text i had written above is one of the value in Question_Text field.....

      what i am looking is

      only  when i choose this value from above straight table then  only i want to display the below straight  table other wise it should hide

       

      Any help please

       

      thanks

      naveen

        • Re: hide and show
          Avinash R

          Question_text is added in the text box ?? if so then create a variable to show and hide the straight table like

          vShow=0

          then on click of the text box add  action >Action type External>Set variable > vShow >1


          and in the straight go to Layout >show> conditional> =vShow


          Hope this helps you

            • Re: hide and show
              naveen kumar

              I think i didn't explained it well ...

              question_text is a dimension in a straight table

               

               

               

              'Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'

              this one is a value in that question_text field

               

              only  when i choose this value from above straight table then  only i want to display the below straight  table other wise it should hide


              so to achieve this hide and show thing,in below straight table layout condition i wrote this


              =Question_Text='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'


              unfortunately which is not working


                • Re: hide and show
                  Vineeth Pujari

                  Hi Naveen,

                   

                  An efficient solution would be to index your question text instead of matching text values.

                   

                  You should then use the following forexample;

                  =if(Question_Index = 1,0,1)

                   

                  The Reason being you may have special characters in your string and to modify such string literals later would be a pain,

                  use Autonumber() to index your question table.

                  LayoutConditional.png

                  • Re: hide and show
                    Avinash R

                    So you have 2 straight tables ? then his should work check you have any space at the start or the end ...and you should select only one value in the upper straight table if its more than one values it won't work

                • Re: hide and show
                  Vineeth Pujari

                  @Hi Naveen,

                   

                  An efficient solution would be to index your question text instead of matching text values.

                   

                  You should then use the following forexample;

                  =if(Question_Index = 1,0,1)

                   

                  The Reason being you may have special characters in your string and to modify such string literals later would be a pain,

                  use Autonumber() to index your question table.

                    • Re: hide and show
                      naveen kumar

                      can you elaborate a bit please..i mean do i need to do anything at script ?

                      where should i have to use this index and auto number function

                        • Re: hide and show
                          Vineeth Pujari

                          Lets assume the below is your load script

                           

                          Questions:

                          LOAD

                          Autonumber(Question_Text) as Q_ID,  //Basically a unique identifier to your Question text.

                          Question_Text,

                          Otherfield1,

                          Otherfield2

                           

                          FROM XxxxxxxTable;

                           

                          Autonumber() will create number values for all your rows of data.

                          Now your selections in Questions_Text will also have a possible value in Q_ID which you can use instead of question text.

                           

                          Example;

                          Q_ID                                                  Question_Text                    Otherfield1                 Otherfield2

                          1                                                  Question1 here                         xxxxxxx                    yyyyyyy

                          2                                                  Question2 here                         wefwefw                    ergerger

                          3                                                  Question3 here                         trhrtndfbd               rgergegre

                      • Re: hide and show
                        Vineeth Pujari

                        Hi Naveen,

                         

                        Has your issue been resolved?