topic Re: Calculated Dimension in QlikView

Calculated Dimension

zagzebski — Fri, 01 Feb 2013 16:23:46 GMT

I am struggling creating a simlpe calculated dimension in a straight table

Basically all I want is a list box that would take the "ZONE" field below and create a "SEGMENT" field that would have the following criteria ..if begins with "USA" than "USA", otherwise "NON-USA"

ZONE

USA - NE

USA - SW

USA - SE

CANADA - W

CANADA - E

MEXICO - W

MEXICO - E

What my calculated dimension (in a list box) would be:

SEGMENT

USA

NON - USA

Re: Calculated Dimension

zagzebski — Fri, 01 Feb 2013 16:24:46 GMT

apologize not trying to do it in a straight table... wabt to do it in a LIST BOX for selection by the end user

Re: Calculated Dimension

swuehl — Fri, 01 Feb 2013 16:29:05 GMT

From the field selection drop down in list box properties, select <Expression> and enter

=if(Left(ZONE,3)='USA','USA','Non USA')

Hope this helps,

Stefan