topic Re: Conditional hide/show columns with multiple selections. in QlikView

Conditional hide/show columns with multiple selections.

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

Hi there,

I have a bit of a weird problem. I have been tasked with showing/hiding columns based on a current selection. I am able to do that with a condition like:

if(isnull(GetFieldSelections([Rule Description])), 1, 0)

if(Index([Rule Description], 1, 1), 1, 0)

if(Index([Rule Description], 2, 1), 1, 0)

if(Index([Rule Description], 4, 1), 1, 0)

if(Index([Rule Description], 5, 1), 1, 0)

if(Index([Rule Description], 14, 1), 1, 0)

So, if there is no selection, show all the fields. If the [Rule Description] field has a 1, show the column else hide it, etc.

The problem I've run into, is that if someone selects multiple [Rule Description]s it doesn't show any of the columns with this formula in it. What are my options for getting around this? Any ideas?

Thanks!

Re: Conditional hide/show columns with multiple selections.

pradosh_thakur — Tue, 31 Oct 2017 13:58:29 GMT

try this

if(wildmatch(getfieldselections([Rule Description]),*1*)>0,[Rule Description])

Re: Conditional hide/show columns with multiple selections.

shinnickr — Tue, 31 Oct 2017 14:10:26 GMT

I get an error in expression during the end part. if(wildmatch(getfieldselections([Rule Description]),*1*)>0,[Rule Description])

Re: Conditional hide/show columns with multiple selections.

pradosh_thakur — Tue, 31 Oct 2017 14:12:03 GMT

if(wildmatch(getfieldselections([Rule Description]),"*1*")>0,[Rule Description])

Missed the quotes

Re: Conditional hide/show columns with multiple selections.

Mark_Little — Tue, 31 Oct 2017 14:18:49 GMT

HI Ryan,

Not sure exactly how you are trying to show and hide fields. Could you maybe explain a little more in plain English the logic to show and hide?

But from your above script

if(Index([Rule Description], 1, 1), 1, 0)

You are not comparing the result i.e Index([Rule Description], 1, 1) = 'Something',1,0

Mark

Re: Conditional hide/show columns with multiple selections.

shinnickr — Tue, 31 Oct 2017 14:44:49 GMT

Looks like it's single quotes instead of double. But it's actually showing all of the columns when I choose a single rule now, instead of just the ones I filtered on. I think because of the >0? I will continue working with it!

Re: Conditional hide/show columns with multiple selections.

Anonymous — Tue, 31 Oct 2017 14:50:09 GMT

Try

=SubStringCount(concat ([Rules Description],'|'),1)

Re: Conditional hide/show columns with multiple selections.

shinnickr — Tue, 31 Oct 2017 14:52:46 GMT

Hi Mark,

I am using the "Enable Conditional" selection in the chart properties.

So if(Index([Rule Description], 1, 1), 1, 0) - If there is a 1 in [Rule Description], show(1), else hide(0). This is working for me on a single selection level. So if I put this into 5 out of the 10 columns, when choose a [Rule Description] with a 1 in it, it shows the 5 columns I want to, and hides the other 5. But if I choose multiple [Rule Description], it does not show any of the columns with the conditional filtering on it.

Does this make any more sense? I'm sorry if I'm being confusing! If there's anything else I can elaborate on that might be more helpful let me know.

Re: Conditional hide/show columns with multiple selections.

Mark_Little — Tue, 31 Oct 2017 15:10:30 GMT

Hi,

It is probably worth taking a look at the link below,

Dynamic Tables and Graphs

This is the approach to making table where columns are shown and hidden depending on selections.

Mark

Re: Conditional hide/show columns with multiple selections.

shinnickr — Tue, 31 Oct 2017 15:48:13 GMT

I took a look and tried to make it work and maybe I'm not fully understanding it, but I don't think it's exactly what I'm looking for. That is hiding/showing columns based on multiple different dimensions being chosen. I am looking to hide/show the columns based on a single dimension.

Re: Conditional hide/show columns with multiple selections.

Mark_Little — Tue, 31 Oct 2017 15:55:45 GMT

Hi Ryan,

I am struggling to understand exactly how you are trying to do this.

So is it something like IF A and C is selected in field1, then show columns 1,4,6

IF A is Selected in field1, Show 1,2

Mark

Re: Conditional hide/show columns with multiple selections.

shinnickr — Tue, 31 Oct 2017 15:57:57 GMT

Yes exactly.

Re: Conditional hide/show columns with multiple selections.

Mark_Little — Wed, 01 Nov 2017 08:51:49 GMT

Morning Ryan,

I would be looking at something like

if(isnull(GetFieldSelections([Rule Description])) OR GetFieldSelections([Rule Description]) = 'A,B',

So you are just saying when nothing is selected or the certain selections (A and B in the above example - replace with your needed selections) show me this column.

If you are not sure what you need to replace A and B with, create a text box and add the function

=GetFieldSelections([Rule Description])

Make your selections and it will show you what is needed.

Mark

Re: Conditional hide/show columns with multiple selections.

shinnickr — Wed, 01 Nov 2017 17:28:25 GMT

Good morning Mark,

I appreciate the help on this!

I like your idea, it's simple and makes sense. The only problem is that I have 14 different Rule Descriptions, and people will be dynamically picking and choosing which ones they want. So I'd have to hard code every single description in there with all the different possible combinations.

Someone above suggested using wildmatch() with getfieldselections() and I've gotten it to work with that!

Thanks again for the help and talking it through with me. It's helped me understand it all a bit more.

Re: Conditional hide/show columns with multiple selections.

shinnickr — Thu, 02 Nov 2017 18:51:09 GMT

After some trial and error I managed to get this to work.

I have 14 different [Rule Description]s, all numbered 1), 2), 3), etc. So using the formula below I am able to do - if no [Rule Description] is selected, show the column. And then when the selection has a '3) ' in it, show the selection. By doing the wildmatch I was able to show the required columns with multiple selections.

if(isnull(GetFieldSelections([Rule Description])), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*3) *'), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*8) *'), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*9) *'), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*10) *'), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*11) *'), 1, 0)

if(wildmatch(getfieldselections([Rule Description]),'*12) *'), 1, 0)

I hope this makes sense for anyone who might possibly have the same problem that I did!