Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

sakamsureshbabu
Contributor

calculated dimension

what is the use of calculated dimension.......

exp line with examples... 

9 Replies

Re: calculated dimension

Hi,

1. Calculated dimension means you have to filter some data from n Number of rows,

2. Need to remove the NULL value from front end in the chart

Load * inline

[ Regions,Customer,Sales

A,C1,4582

B,C2,4586

C,C3,2563

D,C2,2587 ];

Suppose in this case you want chart for only A and D regions then use calculated dimension

Dimension:- If(Match(Region,'A','D')

Expression:- Sum(Sales)

Note:- Click on the Suppress When Value is Null option, also if you use later version of the QV then this feature added in the Straight chart and bar chart.

Hope this helps

Anand

diego_alegre_nu
New Contributor II

Re: calculated dimension

Othe possible use is to concatenate in one field two or more existent fields, codes and description, for example.

=CustomerCode &' - ' CustomerName

sakamsureshbabu
Contributor

Re: calculated dimension

HI Alegre

=IF(Match(ORNAMENTTYPE,'BRAND={Y}'))

this is correct or not

ornamenttype and brand are two separate columns 

Re: calculated dimension

In brand which type of value stored, if it stored Y then it is not correct you have to use like

=IF( Match(BRAND, 'Y')



Regards

Anand

sakamsureshbabu
Contributor

Re: calculated dimension

in Calculated dimension can we use conditions

like in one dimension (ornament type) this dimension values filter out by using two conditions those are

1)    BRAND={Y}

2) BILL = gold

how can i use this

Not applicable

Re: calculated dimension

Through the use of the calculated dimensions you can essentially solve the following problems:

- Create new simple dimensions directly when you design your reports (not recommended but possible) through pure concatenation of two or more fields previously loaded in your document.

  Example: Dimension = PRE_COD&ITEM_COD


- Connect your dimension to a pre-defined mathematical condition (it requires, in addition to the expression, to include dell'Arrg () statement, with the "aggr dimension" equal to same dimension you want to show in your object)

    Example:

Dimension = Aggr(  if(  Sum({Year={<$(vPreviousYear)}>}SALES) > Sum({Year={<$(vCurrentYear)}>}SALES)  ,'PRE_COD'),  PRE_COD)

The expression shows only items for whose last year sales exceed current year sales

- Show/Hide dimension relating it to a variable or to a mathematical function

  Example:

Dimension = if($(vShowDim1)=1,'DIM1','DIM2')

                    or if($(vShowDim1)>$(vShowDim2),'DIM1','DIM2')

sakamsureshbabu
Contributor

Re: calculated dimension

thanks

Not applicable

Re: calculated dimension

Please mark my answer as correct if you met!

sakamsureshbabu
Contributor

Re: calculated dimension

ok Mr Carlo

Community Browser