10 Replies Latest reply: Jul 4, 2016 3:26 AM by CHAN TSZ CHUN JACKY RSS

    hide and show straight table

    naveen kumar

      Hello All,

       

      i am trying to write two layout conditions in a straight table.....

       

      1)straight table should enable only when location and locationquality has selected ..

       

      so i wrote in straight table layout this :

       

      getselectcount(location)=1 and getselectcount(locationquality)=1

       

      which is working great

       

       

       

      Untitled.png

      so now  if i select either one from these two values then only i want this same straight table to be hidden

       

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

      or

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

       

       

      Untitled.png

       

       

       

       

      so in the same straight table layout condition i write this

       

      GetSelectedCount(LOCATION)=1 AND GetSelectedCount(LocationQuality)=1 AND

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

      OR Question_Text<>'Has the adherence of the plant to the prescribed sample management processes (& feedbacks were provided by the auditor) found to be satisfactory ?')



      but this is not working ........?please can any one suggest me whats wrong in this layout condition



      PFA files



      thanks

      naveen



        • Re: hide and show straight table
          Prashant Sangle

          Hi,

           

          what is your requirement?? You don't want to show those 2 description in straight table??

          then create calculated dimension where you can avoid those 2 desription

          or in script you can avoid those description

          or in script you can create flag for those 2 description and use in chart used expression Sum({<flag={"Value'}>}Sales)

           

          Regards

            • Re: hide and show straight table
              naveen kumar

              i do want to show them.....and at the same i want hide table if either one value is selected

                • Re: hide and show straight table
                  CHAN TSZ CHUN JACKY

                  Chart Properties--> Layout -->Show--> Conditional--> if(getselectedcount(field)=1,1,0)

                  1-show 0-Hide  FYR: Hide object if "Month" is not selected. | Qlik Community It is the easiest way for me, hope this helps!

                    • Re: hide and show straight table
                      naveen kumar

                      i am able to find a partial solution ,by writing this in layout conditon...

                       

                       

                      GetSelectedCount(location)=1 and GetSelectedCount(locationquality)=1 and  if(Description='Has the adherence of the plant to the prescribed sample management processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1)

                      Untitled.png

                       

                      but this is not working if i add one more  i mean this

                      GetSelectedCount(location)=1 and GetSelectedCount(locationquality)=1 and  (if(Description='Has the adherence of the plant to the prescribed sample management processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1)

                      or

                      if(Description='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1))

                       

                       

                      Untitled.png

                       

                      i think my syntax is wrong ...can u help me in writing this ...plz

                        • Re: hide and show straight table
                          CHAN TSZ CHUN JACKY

                          IF(Count(distinct (location)) >1 and (Count(distinct (locationquanlity)) >1 and (Count(distinct (Description)) >1 , 0,1)

                          Hope this helps, the direction should be this way

                            • Re: hide and show straight table
                              naveen kumar

                              see this conditon

                              (Count(distinct (Description)) >1 , 0,1)

                              it will hide the straight table if you select any value from the table..

                               

                              but my requirement is only when these two values were selected then only straight table should hide

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

                                  or

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

                               

                               

                              if any other value from the same straight table has selected then it shouldnt hide

                    • Re: hide and show straight table
                      naveen kumar

                      i am able to find a partial solution ,by writing this in layout conditon...

                       

                       

                      GetSelectedCount(location)=1 and GetSelectedCount(locationquality)=1 and  if(Description='Has the adherence of the plant to the prescribed sample management processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1)

                      Untitled.png

                       

                      but this is not working if i add one more  i mean this

                      GetSelectedCount(location)=1 and GetSelectedCount(locationquality)=1 and  (if(Description='Has the adherence of the plant to the prescribed sample management processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1)

                      or

                      if(Description='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?',0,1))

                       

                       

                      Untitled.png

                       

                      i think my syntax is wrong ...can u help me in writing this ...plz