topic Re: Conditional show hide values in list box in QlikView

Conditional show hide values in list box

musketeers — Mon, 09 Feb 2015 11:02:00 GMT

Hi,

I have two list box.

In first list box I have IDs values 1, 2 and 3.

In second list box I am displaying the Product names.

If I select ID = 1 in first list box, I wand to display all product name except the product PRODUCT-1.

For the rest of the IDs in first list box, I need to display all product names in second list box.

to do this I have used if condition in second listbox, but it is not hiding, it is disabling the PRODUCT-1.

I have used Hide Exclude option also but it is not correct option in my case.

I just do not want to display PRODUCT-1 wher ID = 1 is selected in first list box.

Thanks

Re: Conditional show hide values in list box

alexandros17 — Mon, 09 Feb 2015 11:03:59 GMT

In setting your condition write the expression in this way:

If(Cond, Display Item I want, Null())

so "else" option is set to null

Let me know

Re: Conditional show hide values in list box

musketeers — Mon, 09 Feb 2015 11:32:49 GMT

Yes you are right for ID = 1. I have written like this:

IF(ID = 1 and not(match(Product, 'PRODUCT-1')), Product)

So when I am selecting ID = 1 in first list box, the second list box is working fine and it is not displaying PRODUCT-1.

But when I am selecting ID =2 or 3 from first list box, my second list box is empty.

Thanks

Re: Conditional show hide values in list box

alexandros17 — Mon, 09 Feb 2015 12:41:37 GMT

Could you share your document?

Re: Conditional show hide values in list box

musketeers — Mon, 09 Feb 2015 14:46:16 GMT

Hi,

I am sorry, I do not have document. But I am providing a sample. Hope it will help.

I think I can not attach file so I am providing a image.

Also please consider both table as island table. There is no link between them in data model.

Thanks

Re: Conditional show hide values in list box

alexandros17 — Mon, 09 Feb 2015 15:03:56 GMT

Use this expression in the second listbox

=IF(GetFieldSelections(ID)=1, If(wildmatch(StName,'st1')>0, StName, null()), StName)

let me know

Re: Conditional show hide values in list box

musketeers — Mon, 09 Feb 2015 15:59:49 GMT

Hi,

Its working but it is disabling the unwanted values. Do we have any way not to display unwanted values.

Thanks

Re: Conditional show hide values in list box

Anonymous — Mon, 09 Feb 2015 16:08:12 GMT

Can you try "Hide Excluded" in the Listbox properties.

Is this what you want to achieve?

Re: Conditional show hide values in list box

reshmakala — Mon, 09 Feb 2015 16:08:51 GMT

Check the "Hide excluded" button in list box properties.

Re: Conditional show hide values in list box

musketeers — Tue, 10 Feb 2015 05:52:50 GMT

Hi,

No Hide Exclude is not correct option for me as it will hide the unwanted values in first look. But when user will select a values from the list then Hide Exclude option will hide remaining unselected values.

So it is not correct one.

Thanks

Re: Conditional show hide values in list box

jazzsran — Fri, 24 Nov 2017 12:21:32 GMT

Hi Rajneesh,

Were you able to find the solution for this?

I have similar condition where the non related values should hide in the list box1 based on the selection in list box2, however later when selecting the values from the list box1, user should be able to see the non- selected options as well here, means it should show all the values according the list box2.

I was able to hide the values in the list box1 using the below expression but when i am selecting from the available values in the list box1 later, all the other values from list box1 are also disappearing except the selected one.

EXP: aggr(only({<Dimension= P(Dimension)>}Dimension),Dimension)

Can anyone help?

Thanks in advance