topic Re: Multiple Calculated Dimensions in QlikView

Multiple Calculated Dimensions

danielnevitt — Mon, 07 Oct 2013 14:17:03 GMT

Hi,

I'm trying to restrict the data shown on a graph by using calculated dimensions.

The restrictions I would like to apply are:

DESK_CD = Crude AND

INTERNAL_IND <> Inter-Strategy AND

TRADE_STATUS_IND = Finalized OR New Trade OR Parceled OR PL Run OR Realized

Is this possible?

Any help will be much appreciated.

Regards,

Daniel

Re: Multiple Calculated Dimensions

v_iyyappan — Mon, 07 Oct 2013 14:25:30 GMT

Hi,

U can restrict the filter in set analysis.

Try like this

=Sum({<DESK_CD = {'Crude'}, INTERNAL_IND -= {'Inter-Strategy'}, TRADE_STATUS_IND={'Finalized', 'New Trade', Parceled', 'PL Run', 'Realized'} >}sumfield)

regards,

Re: Multiple Calculated Dimensions

danielnevitt — Wed, 09 Oct 2013 16:06:19 GMT

Thanks for your help.

Regards,

Daniel