topic Re: Calculated Dimension in QlikView

Calculated Dimension

cbaqir — Tue, 18 Aug 2015 19:40:50 GMT

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

Re: Calculated Dimension

Anonymous — Tue, 18 Aug 2015 20:05:20 GMT

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)

Re: Calculated Dimension

cbaqir — Tue, 18 Aug 2015 20:27:35 GMT

Thanks... I was so close!

Re: Calculated Dimension

cbaqir — Tue, 18 Aug 2015 20:37:00 GMT

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

Re: Calculated Dimension

Anonymous — Tue, 18 Aug 2015 20:46:13 GMT

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)

Re: Calculated Dimension

cbaqir — Tue, 18 Aug 2015 20:46:28 GMT

Nevermind - I think I got it.

Change field to expression and

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

Re: Calculated Dimension

Anonymous — Tue, 18 Aug 2015 20:47:29 GMT

great work!