Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

zagzebski
Contributor

Calculated Dimension

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

2 Replies
zagzebski
Contributor

Re: Calculated Dimension

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

MVP
MVP

Re: Calculated Dimension

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

Community Browser