topic Re: Expression in QlikView

Expression

suvechha_b — Wed, 30 Sep 2015 08:49:25 GMT

How to write the following expression :

In Dimension :

=if(Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12' AND [Fiscal Month]= AND [Fiscal Year]=,[Product/Code],Null())

Note :

Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12'

and [Fiscal Month] and [Fiscal Year] can be anything .

I need to select the product which fullfill the : Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12'

I need to pull the report who fulfill the condition

Re: Expression

swuehl — Wed, 30 Sep 2015 08:55:56 GMT

Sorry, it's unclear to me what you are trying to achieve, especially it's hard to understand without knowing your data model.

If the user selects the values like shown above, this should already filter the data in your data model and influence any exiting report. Maybe you don't need to create a calculated dimension at all.

Re: Expression

tresB — Wed, 30 Sep 2015 08:57:49 GMT

Put the conditions in the set expression rather and try like:

Dim: [Product/Code]

Exp: Sum({<Measure={ORDERS}, Accuracy={'ARITH -1 month'},[Report Months]={12}>} AmountField)

Adjust your expression(aggregation function and measure) accordingly.

Re: Expression

jonathandienst — Wed, 30 Sep 2015 09:01:35 GMT

Rather than using a calculated dimension, put those filters in the table/chart expressions:

{<Measure={'ORDERS'} AND Accuracy={'ARITH - 1 month'} AND [Report Months]={12}>}

This will usually perform better than a calculated dimension.