hide and show straight table

[kunkumnaveen]

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

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 ?

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

[PrashantSangle]

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

[kunkumnaveen]

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

[#4]

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!

[kunkumnaveen]

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)

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))

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

[#6]

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

[kunkumnaveen]

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

[kunkumnaveen]

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)

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))

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

[#9]

if(getfieldselections (Description) ='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?' or getfieldselections (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) this would work now! Sorry for misunderstanding. Hope this helps!

[kunkumnaveen · Accepted solution]

It worked out in this way

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 ?'

or

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