topic Re: conditional layout in QlikView

conditional layout

srujanaponnuru — Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have a search box with 2 fields named as BI_App_Name and Technology. so when I search any application in BI_Appl_Name I displayed all the list boxes corresponding to that.

for all the list boxes I have given the layout condition as below :

=if(GetFieldSelections(BI_App_Name)>0,1,0)

when i search for technology in search box I willg et different list boxes which are not in BI_appl_Name so for that I have given layout condition as

=if(GetFieldSelections(Technology)>0,1,0)

Here my question and doubt is

when I search any application in BI_Appl_Name, i will get one list box names as Technologies where I listed all techonology names. and when i select any technology name in that list box it has to go to Technology tab. for that I have given nested if condition as

=if(GetFieldSelections(Application_Name)>0,1,if(GetFieldSelections(Technology),2))

but this expression is not working

please help

Re: conditional layout

Anil_Babu_Samineni — Thu, 20 Oct 2016 14:27:14 GMT

What is the intend you are having this and use and in between nested if for conditional

Re: conditional layout

el_aprendiz111 — Thu, 20 Oct 2016 14:34:32 GMT

Hi,

=if(GetFieldSelections(Technology),2,if(GetFieldSelections(Application_Name)>0,1))

Re: conditional layout

srujanaponnuru — Thu, 20 Oct 2016 14:44:09 GMT

with that condition it is going to technology page but the list box is appearing on that page as well.

when I click any technology in that list box, that list should disappear.

Re: conditional layout

Anonymous — Thu, 20 Oct 2016 14:54:42 GMT

are you looking for calculations based on / ignoring the listboxes ..

for example :

sum({<category={'abc'},listbox1=,listbox2=,listbox3=>}value) /

sum({<category={'abc','xyz'},listbox1=,listbox2=,listbox3=>}total value)

listbox1, listbox2 are the listbox whose selection should not be effected.

Re: conditional layout

srujanaponnuru — Fri, 21 Oct 2016 06:30:00 GMT

hi,

attached is the sample qv

when i am selecting selected list in the list box , the current list box it shoulg hide and show me the other list box but it is not happening like that.. i am able to see both the list boxes.

for example: click Application name field search list box, then Technologies list box will appear, then if i select C#, then Application Name list box is appearing but the Technologies list box is not hiding.

so please help me

Re: conditional layout

Fri, 21 Oct 2016 06:42:48 GMT

Hi Nazeer,

Get Field Selections() is used to return a string value , it is always better to use Get Selected Count()

[which returns the count of the selections made in field] for layout

operations.

Regards,

Balakrishnan.R

Re: conditional layout

avinashelite — Fri, 21 Oct 2016 06:44:50 GMT

I checked your app ...their is no associated data for the selection you making and when make the selection it deselecting the non-associated value from the other list box ....add the associated data and check or change your conditions

Hope this helps you

Re: conditional layout

srujanaponnuru — Fri, 21 Oct 2016 07:20:20 GMT

no its not working

Re: conditional layout

avinashelite — Fri, 21 Oct 2016 07:26:57 GMT

hmmm...try like this clear all your selection and then try your above mentioned example ...since the list box are hiding your not able to track the selection ...add the current selection box and you would see the current selections what you have made

Re: conditional layout

srujanaponnuru — Fri, 21 Oct 2016 07:30:30 GMT

i dont want to see the current selection in list box,

when i click on C# in technologies list box, it has to navoigate to Application name list box and then hide the tehncologies list box. but its not happening

Re: conditional layout

avinashelite — Fri, 21 Oct 2016 08:35:37 GMT

Did you tried what I mentioned in my last post ?

I have attached the sample file, search for the C# in search box and then check whether it s working according to your requirement ...

Re: conditional layout

Frank_Hartmann — Fri, 21 Oct 2016 08:40:17 GMT

have a look at attached sample

hope this helps

Re: conditional layout

srujanaponnuru — Fri, 21 Oct 2016 10:27:30 GMT

sorry guys its not working in any way, we have tio use triggers i guess

Re: conditional layout

Frank_Hartmann — Fri, 21 Oct 2016 10:40:15 GMT

So this is not your requirement?

Re: conditional layout

srujanaponnuru — Fri, 21 Oct 2016 10:51:16 GMT

i have added more fields to explain clearly..

here in the qvw file if we select application name in search box , technology list box is appearing, then on selecting tableau in that it is displaying application name list box but technology is not hiding.

Please check

Re: conditional layout

Frank_Hartmann — Fri, 21 Oct 2016 10:56:03 GMT

like this?