topic Re: Calculated Dimension Query? in QlikView

Calculated Dimension Query?

MuraliPrasath — Wed, 06 Jan 2016 06:35:20 GMT

Hi QV Team,

I've three fields

1.Designation,

2.Directions

3.Sales.

I just want to have only two columns 1. Designation 2, Sales.

In Designation where Direction field is equal to North. Need help on this?

In Sales column Sum( Distinct ( Sales).

Re: Calculated Dimension Query?

jagan — Wed, 06 Jan 2016 06:41:08 GMT

Hi,

Try like this using Set analysis

Dimension: Designation

Expression: Sum({<Direction={'North'}>}Sales)

Hope this helps you.

Regards,

Jagan.

Re: Calculated Dimension Query?

MuraliPrasath — Wed, 06 Jan 2016 06:44:02 GMT

Hi Jagan,

In Dimension Field I need to restrict Designations where Directions=North. Is this possible?

Re: Calculated Dimension Query?

PrashantSangle — Wed, 06 Jan 2016 06:44:03 GMT

Hi,

2 ways to achieve it.

1: At front End:

Create Calculated Dimension

Calculated Dimension : If(wildmatch(Directions,'North'),Designation)

Expression Sum(Sales)

and Suppress Null from dimension Tab

2: At Back End create new field

If(wildmatch(Directions,'North'),Designation) as NorthDesignation

and use North Designation field as Dimension.

Regards,

Re: Calculated Dimension Query?

MuraliPrasath — Wed, 06 Jan 2016 06:47:50 GMT

Thanks Max & Jagan.

Re: Calculated Dimension Query?

Kushal_Chawda — Wed, 06 Jan 2016 06:49:47 GMT

In script create the Flag as

if(Direction ='North',1,0) as DirectionNorthFlag

Now create the straight table

Dimension:

Designation

Expression:

Sum({<DirectionNorthFlag={'1'}>} distinct Sales)

Re: Calculated Dimension Query?

jagan — Wed, 06 Jan 2016 06:56:11 GMT

It is possible, but it is not suggested to use Calculated Dimensions because of performance issues. Always try to avoid Calculated dimensions. I am not sure why you are not using Set Analysis for this purpose?

Regards,

Jagan.