topic Re: calculated Dimension in QlikView

calculated Dimension

Wed, 25 Jul 2012 10:57:51 GMT

I am reading data from excel sheet, one of the column in excel have value as

Now I want to add that column in pivot table as Dimension. But want only B,C,D value to be appear in that column in Pivot table. How i can achieve this with calculated dimension.

Re: calculated Dimension

perumal_41 — Wed, 25 Jul 2012 11:08:28 GMT

Hi Ramkumar ,

if possible Please upload sample application for reference.

Regards

Perumal A

Re: calculated Dimension

nilesh_gangurde — Wed, 25 Jul 2012 12:27:49 GMT

In calculated dimension add the following script.

=if(FieldName <> A ,FieldName,if(FieldName <> E ,FieldName,if(FieldName <> F,FieldName)))

Where "FieldName" is the name of Column in which you have values such as A,B,C,D,E,F etc.

It Will Work for sure.

Regards,

Nilesh Gangurde

Re: calculated Dimension

Wed, 25 Jul 2012 12:34:25 GMT

Hi ramkumar,

you can add a calculated dimensions to the pivot-table (or to any other chart as well).

For Ex.: creating a calc dim out of field Type:

=if( Type = 'B' or Type = 'C' or . . . , Type)

May be you need to build another condition using functions like wildmatch() etc.

HtH+

Roland

Re: calculated Dimension

CELAMBARASAN — Wed, 25 Jul 2012 13:01:40 GMT

Try this

If(Match(Type,'B','C','D'), Type)