topic Re: Conditional Hide a textfield with more listboxes and more values in QlikView

Conditional Hide a textfield with more listboxes and more values

Mon, 29 Jul 2013 13:10:45 GMT

Hello i have 3 Listboxes with a lot of values

Listbox 1 (name: #box1) contains "Material ID" etc....

Listbox 2 (name: #box2) contains "Spec ID" etc.....

Listbox 3 (name: #box3) contains "Sampleplan ID" etc....

Now i created a textfield with some informational text. I want this textfield been hidden when "Material ID", "Spec ID" and/or "Sampleplan" is selected in the listboxes.

Is this possible? and How?

Thanks

Re: Conditional Hide a textfield with more listboxes and more values

Anonymous — Mon, 29 Jul 2013 13:17:23 GMT

You can test for GetCurrentSelections(). Using something like this in your Show condition:

NOT wildmatch(GetCurrentSelections(),'*MaterialID*','*SpecID*','*SampleplanID*')

Jonathan

Re: Conditional Hide a textfield with more listboxes and more values

ariel_klien — Mon, 29 Jul 2013 13:22:59 GMT

you can use: GetFieldSelections() function.

use it in the Text Object Properties > layout > show > conditional.

write something like this:

GetFieldSelections(Name_of_Filed_ #box1) <>'Material ID' or

GetFieldSelections(Name_of_Filed_ #box2) <>'Spec ID' or

GetFieldSelections(Name_of_Filed_ #box3) <>'Sampleplan ID'

Ariel

Re: Conditional Hide a textfield with more listboxes and more values

Mon, 29 Jul 2013 14:15:09 GMT

Ok now i have:

GetFieldSelections(#PRODUCTS)<>'Material ID' and

GetFieldSelections(#SPECS)<>'Spec ID' and

GetFieldSelections(#SAMPLEPLAN)<>'Sampleplan ID'

Works a litle bit. But when i select more fields from #PRODUCS (#Box1) it wont work annymore. Works when i only select 'Material ID'

if i change the "and" with a "or" it works on nothing.

Re: Conditional Hide a textfield with more listboxes and more values

kaushiknsolanki — Mon, 29 Jul 2013 16:01:47 GMT

Hi,

Try this.

If(Wildmatch(concat(#PRODUCTS,','),'Material ID') or

Wildmatch(concat(#SPECS,','),'Spec ID') or

Wildmatch(concat(#SAMPLEPLAN,','),'Sampleplan ID'),0,1)

Regards,

Kaushik Solanki

Re: Conditional Hide a textfield with more listboxes and more values

Tue, 30 Jul 2013 06:14:14 GMT

Again, if i select more then the Material ID from #PRODUCTS this is not working.

Re: Conditional Hide a textfield with more listboxes and more values

kaushiknsolanki — Tue, 30 Jul 2013 06:28:28 GMT

Hi,

Ohh I am sorry i forgot to place the * in the expression.

If(Wildmatch(concat(#PRODUCTS,','),'*Material ID*') or

Wildmatch(concat(#SPECS,','),'*Spec ID*') or

Wildmatch(concat(#SAMPLEPLAN,','),'*ampleplan ID*'),0,1)

Regards,

Kaushik Solanki

Re: Conditional Hide a textfield with more listboxes and more values

Tue, 30 Jul 2013 06:55:13 GMT

And now it is not showing when i have selected nothing

Re: Conditional Hide a textfield with more listboxes and more values

Kushal_Chawda — Tue, 30 Jul 2013 07:07:16 GMT

Hi,

Create 3 variables as below

vField1 = if(GetSelectedCount(Mese)>=1 ,0,1)

vField2 = if(GetSelectedCount(Litri1)>=1 ,0,1)

vField3 = if(GetSelectedCount(Cum)>=1 ,0,1)

Go to Object Properties > layout > show > conditional put condition (vField1 or vField2 or vField3)

Re: Conditional Hide a textfield with more listboxes and more values

Tue, 30 Jul 2013 07:16:27 GMT

Hi sneekyshadow

please see the attached example for help.

Maybe you have to modify the condition to get the result you expect.

Good luck!

Rainer

Re: Conditional Hide a textfield with more listboxes and more values

Tue, 30 Jul 2013 09:10:42 GMT

Thanks a lot. This helped me a lot.

Solution:

If(Wildmatch(concat(#PRODUCTS,','),'*Material ID*') and GetSelectedCount(#PRODUCTS)>0,0,-1) and

if(Wildmatch(concat(#SPECS,','),'*Spec ID*') and GetSelectedCount(#SPECS)>0,0,-1) and

if(Wildmatch(concat(#SAMPLEPLAN,','),'*LVL2 ID*') and GetSelectedCount(#SAMPLEPLAN)>0,0,-1)