topic Re: hide and show in QlikView

hide and show

kunkumnaveen — Sat, 02 Jul 2016 07:07:04 GMT

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

avinashelite — Sat, 02 Jul 2016 07:30:34 GMT

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

kunkumnaveen — Sat, 02 Jul 2016 08:15:27 GMT

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

vinieme12 — Sat, 02 Jul 2016 08:27:06 GMT

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

vinieme12 — Sat, 02 Jul 2016 08:35:18 GMT

@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

avinashelite — Sat, 02 Jul 2016 08:38:43 GMT

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

kunkumnaveen — Sat, 02 Jul 2016 09:33:01 GMT

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

vinieme12 — Sat, 02 Jul 2016 09:57:04 GMT

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

vinieme12 — Mon, 04 Jul 2016 13:22:49 GMT

Hi Naveen,

Has your issue been resolved?