Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

conditional layout

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

16 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
el_aprendiz111
Specialist
Specialist

Hi,

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

srujanaponnuru
Creator
Creator
Author

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.

Anonymous
Not applicable

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.

srujanaponnuru
Creator
Creator
Author

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

Not applicable

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

avinashelite

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

srujanaponnuru
Creator
Creator
Author

no its not working

avinashelite

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