Discussion Board for collaboration related to Creating Analytics for QlikView.
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"
USA - NE
USA - SW
USA - SE
CANADA - W
CANADA - E
MEXICO - W
MEXICO - E
What my calculated dimension (in a list box) would be:
NON - USA
apologize not trying to do it in a straight table... wabt to do it in a LIST BOX for selection by the end user
From the field selection drop down in list box properties, select <Expression> and enter
Hope this helps,