Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
i do want to show them.....and at the same i want hide table if either one value is selected
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!
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
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
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
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
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!
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)