topic Re: hide and show straight table in QlikView

hide and show straight table

kunkumnaveen — Mon, 04 Jul 2016 06:02:13 GMT

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 ?

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

Re: hide and show straight table

PrashantSangle — Mon, 04 Jul 2016 06:14:00 GMT

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

kunkumnaveen — Mon, 04 Jul 2016 06:20:27 GMT

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

Mon, 04 Jul 2016 06:23:54 GMT

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

kunkumnaveen — Mon, 04 Jul 2016 06:32:42 GMT

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)

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

Re: hide and show straight table

Mon, 04 Jul 2016 06:44:44 GMT

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

kunkumnaveen — Mon, 04 Jul 2016 06:51:43 GMT

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 ?

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

kunkumnaveen — Mon, 04 Jul 2016 06:59:24 GMT

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

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

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

Re: hide and show straight table

Mon, 04 Jul 2016 07:00:17 GMT

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!

Re: hide and show straight table

kunkumnaveen — Mon, 04 Jul 2016 07:11:45 GMT

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

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

Re: hide and show straight table

Mon, 04 Jul 2016 07:26:43 GMT

Congrad dude, I seemed to be missed some criteria again!