Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Calculated Dimension

I have a straight table with PROG_PORT as the dimension and several expressions. I've filtered the expressions using an if statement but I am still seeing a line for some PROG_PORT that I don't want to show up so I think I need to filter the dimension.

Dimension (I don't want the following to show up at all 'Minor Project', 'O&M', 'Administration',  'Not Classified', 'N/A'):

=if(PROG_PORT=('Minor Project' or 'Administration'),null(),PROG_PORT)

Example expression: =count(DISTINCT{$<REQ_STATUS={'Open'},PROJ_PROP_CAT={'Project'},DISPLAY_STATUS-={'Close Out'}, PROG_PORT-={'Minor Project', 'O&M', 'Administration',  'Not Classified', 'N/A'}, PRIORITY_TIER={'A', 'AE', 'B', 'C'}, DELIVERY_TIER-={'Bronze'}>} REQUEST_ID)

How should I adjust my Dimension so that 'Minor Project', 'O&M', 'Administration',  'Not Classified', 'N/A' are not displayed at all?

Thanks,

Cassandra

1 Solution

Accepted Solutions
hrlinder
Honored Contributor

Re: Calculated Dimension

for the calculated Dimension you can use

=if(match(PROG_PORT,'Minor Project', 'O&M', 'Administration',  'Not Classified', 'N/A'')>0,null(),PROG_PORT)

you do not Need to restrict PROG_PORT in expression

Example expression: =count(DISTINCT{$<REQ_STATUS={'Open'},PROJ_PROP_CAT={'Project'},DISPLAY_STATUS-={'Close Out'},  DELIVERY_TIER-={'Bronze'}>} REQUEST_ID)

6 Replies
hrlinder
Honored Contributor

Re: Calculated Dimension

for the calculated Dimension you can use

=if(match(PROG_PORT,'Minor Project', 'O&M', 'Administration',  'Not Classified', 'N/A'')>0,null(),PROG_PORT)

you do not Need to restrict PROG_PORT in expression

Example expression: =count(DISTINCT{$<REQ_STATUS={'Open'},PROJ_PROP_CAT={'Project'},DISPLAY_STATUS-={'Close Out'},  DELIVERY_TIER-={'Bronze'}>} REQUEST_ID)

cbaqirdhds
Contributor II

Re: Calculated Dimension

Thanks... I was so close!

cbaqirdhds
Contributor II

Re: Calculated Dimension

What about restricting the same PROG_PORT values in a list box?

hrlinder
Honored Contributor

Re: Calculated Dimension

you can restrict it in the listbox so the user cannot select them

but this is only for the listbox

if you have a Chart with Expression like above, all categorys will be included.

Example expression: =count(DISTINCT{$<REQ_STATUS={'Open'},PROJ_PROP_CAT={'Project'},DISPLAY_STATUS-={'Close Out'},  DELIVERY_TIER-={'Bronze'}>} REQUEST_ID)

cbaqirdhds
Contributor II

Re: Calculated Dimension

Nevermind  - I think I got it.

Change field to expression and

aggr(only({<PROG_PORT-={'Minor Project'}>}PROG_PORT),PROG_PORT)

hrlinder
Honored Contributor

Re: Calculated Dimension

great work!

Community Browser