topic How to make columns in a table appear/disappear based on selection? in QlikView

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 14:01:26 GMT

Hey all,

I have a table in Qlikview with several expressions in it. I want to make them appear when they are selected.

Under the presentation tab of my table properties I select the conditional option. If I write here: ListboxName= 'Columname'

then the column will appear on selection and disappear otherwise. The problem I have is when selecting multiple values this doesn't work anymore.

I think I should work with an if statement and maybe the getSelectedfields function but I have no idea how to do this.

Is there anyone who can help me with this?

Thanks in Advance,

Jens

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 14:41:30 GMT

Hi Jens,

try this in the cond option:


Len (getfieldselections ( Fieldname)) = 0

Hints:

Fieldname is the table-fieldname. Don't use an if-clause in the condition term!

Regards, Roland

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 15:02:31 GMT

Thanks for the response.

Your statement works but I still have the issue that he doesn't show all the values I select.

I have a listbox with all my columnnames and I want the column to become visible in the table when I select it in the listbox.

I can do this for each value but not when I select several options in the listbox.

In your statement I compare whether there is a value selected but I want to check for specific values.

Regards,

Jens

How to make columns in a table appear/disappear based on selection?

jonathandienst — Mon, 25 Oct 2010 15:30:31 GMT

Jens

Assuming that ListBoxName contains column names that you want to conditionally display, then perhaps something like:

=Wildmatch(GetFieldSelections(ListboxName), '*ColumnName1*')>0

If you want the selection to depend on mu;tiple selections, then add more compare strings like this:

=Wildmatch(GetFieldSelections(ListboxName), '*ColumnName1*', '*ColumnName2*')>0

Add as many column names as you need.

Note that if you could possibly select more than 6, then GetFieldSelections needs to be written like:

GetFieldSelections(ListBoxName, ',', 20)

just replace 20 with the maximum possible to likely number of column selections.

Jonathan

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 15:34:54 GMT

Oh, this is a little bit different than i thought before. But now I understand you better and I know what you want. What do you use for your listbox ? $Field?

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 15:38:31 GMT

.... and I follow up Jonathan ......

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 15:41:54 GMT

My listbox contains the names of my columns.

When I select one or multiple values in my Listbox I want the selected columns to become visible in my table.

How to make columns in a table appear/disappear based on selection?

jonathandienst — Mon, 25 Oct 2010 15:43:44 GMT

Jens

Then my earlier post should work for you

Jonathan

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 15:57:01 GMT

Thanks for the response Jonathan.

You solution also works but not when I select multiple values.

When I use:

Wildmatch(GetFieldSelections(ListboxName), 'Column1')>0 in the conditional field of my expression (in the presentation tab of the chart properties)

It shows Column1 in my table(graph) when I select it in my listbox

But when I select multiple values in my listbox I cannot see them in my table anymore.

I want that all the columns that I select appear in my table and this in a flexible way. So when I select only on than only that column should appear, but when I select multiple I want all of the selected to appear.

I am trying to reach this by using the conditional option in the presentation tab of my chart properties. Maybe this isn't the place to do this.

I think I need a condition for each column (expression) saying that if it is in the selected fields show it.

I hope that you have an idea of what I want to reach

Kind regards,

Jens

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 16:32:22 GMT

Hi,

lets try to clear the situation:

I have two database-fields (Type and Amount) and a listbox containing $Field. Then I can use

Wildmatch(GetFieldSelections($Field), '*Type*')>0 in the condition option of the column refering to Type
Wildmatch(GetFieldSelections($Field), '*Amount*')>0 in the condition option of the column for Amount

This should help. Take care of the ( * ) !

To Jonathan:

I can't afford "GetFieldSelection(ListBoxName); My function needs a Fieldname as Parameter ?!?!

How to make columns in a table appear/disappear based on selection?

jonathandienst — Mon, 25 Oct 2010 16:38:58 GMT

You are correct

I had "assumed" that ListBoxName is a field name. Looking at it now, it seems that was wrong.

Jonathan

How to make columns in a table appear/disappear based on selection?

jonathandienst — Mon, 25 Oct 2010 16:40:38 GMT

Jens

I think you need to post your QVW file (or at a sample of it). Then we can be sure to help you without misunderstanding each other.

Jonathan

How to make columns in a table appear/disappear based on selection?

Mon, 25 Oct 2010 17:19:44 GMT

In attachment a sample of my qvw file. Hopefully this makes things more clear.

How to make columns in a table appear/disappear based on selection?

jonathandienst — Mon, 25 Oct 2010 22:12:10 GMT

Jens

Got it working on the Actual table. I only did four fields (Actual, Actual % cont to Growth, Actual % of Total, Actual vs. PY (abs)) , I leave the rest for you.

Needed some special handling for Actual, as it is also contained in the other Measure values.


=If(Len(GetFieldSelections(Measure))>0, Wildmatch(GetFieldSelections(Measure, ',', 20), 'Actual', 'Actual,*', '*,Actual', '*,Actual,*')>0, 0)
=If(Len(GetFieldSelections(Measure))>0, Wildmatch(GetFieldSelections(Measure, ',', 20), '*Actual % of Total*')>0, 0)

Also needed to detect when no measure selected to suppress the display of all expressions.

=If(Len(GetFieldSelections(Measure))>0, ..., 0)

If you want to display all expressions if no selection, change the last 0 to -1....

=If(Len(GetFieldSelections(Measure))>0, ..., -1)

Jonathan