topic Re: Re: Hide and Show by selected Field value in QlikView

Hide and Show by selected Field value

Wed, 20 Aug 2014 13:20:20 GMT

Hi All
I have 3 tables.

If i select any field value in table 1 ,I want to display Table 2 only and table1 should be hide(table2 should be replace same position and place of table1) .

If i select any field value in table2 ,I want to display Table3 only and table1 ,table2 should be hide(table3 should be replace same position and place of table1) .

Thanks

Re: Hide and Show

qlikoqlik — Wed, 20 Aug 2014 13:23:16 GMT

hi Swathi

Use a variable for hide and show and conditional hide in the layout tab of the table

thanks

Padma

Re: Hide and Show

amit_saini — Wed, 20 Aug 2014 13:24:00 GMT

Hi Swath,

Follow this :

How to hide and show a table clicking on command button

Thanks,

Re: Hide and Show

Wed, 20 Aug 2014 13:40:21 GMT

Sorry not based on button click....If I click any field value in table

can any one place sample app

thanks in advance

Re: Hide and Show by selected Field value

Wed, 20 Aug 2014 14:08:29 GMT

Thax for your reply..I am new to QV ,do u have any sample app...

Re: Hide and Show by selected Field value

Anonymous — Wed, 20 Aug 2014 14:12:11 GMT

are the two fields in the two tables same or different?

if they are different, one way is using triggers...go to settings > document properties > triggers > in "field event triggers", select the field you want to enable the trigger on > click on add actions for OnSelect > click Add in the Actions window > select Activate Object and input the object id that you want to activate.

add another trigger for the other field.

there are other ways to do this...may be a sample file will help identify the better solution for your requirement.

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 04:59:32 GMT

I have two different tables,I have tried your solution but unable to successed,Any other possible solutions??can any one pls share some sample apps

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 05:38:17 GMT

hi,

Do you want to perform selection in list box or Table Fields ??

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 05:59:22 GMT

Hi,

Plz find the Attached file for sample application

Regards,

Vivek

Re: Hide and Show by selected Field value

ecolomer — Thu, 21 Aug 2014 06:02:34 GMT

in the attached file is an example of graphics that appear according to the selected option (labels)

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 06:59:11 GMT

Thanks vivek...this is my requirement ,I have 3 straight tables with different dimentions.there is relation ship between each table.

If i select any field value in table1 ,I want to display Table2 only and table1 should be hide(table2 should be replace same position and place of table1) .

If i select any field value in table2 ,I want to display Table3 only, and table2 and table1 should be hide(table3 should be replace same position and place of table1) .

Thanks

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 07:10:23 GMT

Hi,

Please Have a look at attached file in my previous comment.

Regards,

Vivek

Re: Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 07:28:47 GMT

yes I have look into your app....but there is no hide and show objects..it is showing table3 only,see the attached image.

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 07:44:35 GMT

Hi,

Please find the Updated QVW

Re: Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 07:57:37 GMT

Thanku but in your example...you have only expression.

I have 3 tables like 3 different dims and 3 different expressions.

Table1

------

Dim1 expr1 key

A 10 1

B 20 2

Table2

---------

Dim2 expr2 key

C 30 1

D 40 1

If we cliick on "A" table2 should display with C,D values(where Key is same in both tables)and Table 1 should hide.

hope you got my requirement.

thanks

Re: Hide and Show by selected Field value

Thu, 21 Aug 2014 08:14:41 GMT

Hi,

In my application there are three table but they are hidden that why you are not able to see those tables.

Please understand the logic used in that application.

Same way you can achieve this one also.

Regards,

Vivek

Re: Hide and Show by selected Field value

Anonymous — Mon, 06 Apr 2015 08:00:21 GMT

Hi Enrique,

Nice example. Could you explain me the way to do this?

I've been looking de qvw and i didn´t find any conditional expression in the graphics or actions in the labels.

Thanks

Maria

Re: Hide and Show by selected Field value

ecolomer — Mon, 06 Apr 2015 09:22:53 GMT

Para verlo, haz lo siguiente:

- Selecciona Producto

- Botón izquierdo sobre la pestaña de clientes y lo verás

Re: Hide and Show by selected Field value

Anonymous — Mon, 06 Apr 2015 10:01:56 GMT

Vale, veo que tienes una variable que le asignas valor al pulsar el botón (no sabia que la acción desaparecía una vez pulsado).

¿Pero donde asignas esa variable vista a los gráficos que aparecen?