topic Re: Enable condtion on dimension in QlikView

Enable condtion on dimension

zagzebski — Sat, 13 Jun 2015 03:25:01 GMT

I want to create a condition (in enable condition from the dimension tab in a pivot table). I have the following table. I have a list box for the MenuSelection field. Depending on what is selected the dimension in the pivot table will (or won't be enabled):

DynamicDimension table:

MenuSelection Dimension

Revenue Branch

Revenue Department

Revenue Line of Business

Expense Branch

Expense Department

So if the user selects "Revenue" (in the List Box) then in the pivot table Branch, Department and Line of Business will be enabled, but if Expense is selected (in the List Box) then only the Branch or Department dimensions will enabled but the Line of Business dimension field will not be enable because it is not associated with Expenses

Thanks in advance for any help,

Steve

Re: Enable condtion on dimension

Anonymous — Sat, 13 Jun 2015 03:36:00 GMT

Looks like you don't need any condition on Branch and Department dimensions, but need only for Line of Business. Condition will be:

MenuSelection = 'Revenue'

Re: Enable condtion on dimension

zagzebski — Sat, 13 Jun 2015 03:54:57 GMT

Actually that table is just a small representation of many more records. For example I want to set up a dimension for Branch and maybe 7 out of 10 selections in the ListBox are related to Branch. If one of those is selected then Branch will be enabled. Some kind of aggr function or something?

Steve

Re: Enable condtion on dimension

Anonymous — Sat, 13 Jun 2015 04:00:29 GMT

There is no need to over-engineer... Try this, for each dimension:

match(MenuSelections, 'Revenue','Expense', '' ...)

Different list for each dimension.

Re: Enable condtion on dimension

Kushal_Chawda — Sat, 13 Jun 2015 06:16:58 GMT

Go to the chart Properties -> Dimension tab

For Dimension Line of Business put below condition

=if(GetSelectedCount(MenuSelection)>0,

if(GetFieldSelections(MenuSelection)='Revenue',1,0),1)

For Dimensions Branch, Department put below condition

(if(GetSelectedCount(MenuSelection)>0,

if(GetFieldSelections(MenuSelection)='Revenue',1,0),1)) or

(if(GetSelectedCount(MenuSelection)>0,

if(GetFieldSelections(MenuSelection)='Expense',1,0),1))

Re: Enable condtion on dimension

Sat, 13 Jun 2015 12:06:57 GMT

use this as calculated dimension:

if(match(Pivot_Table_Dimension,$(=chr(39)&Concat(Dimension ,chr(39)&','&chr(39))&chr(39))),Pivot_Table_Dimension)

and then suppress null values

sample is attached