Raw Data Format (Can QV Re-Organize?)

Sun, 26 Jun 2011 19:36:30 GMT

Hi Gang - Question for the general forum. I have raw data reported by our server that isnt exactly an optimal configuration for QV. That is, instead of having two columns for product line revenue (one for product line and one for revenue); the data is combined into one column "product line revenue."

I want to user to be able to simple click the Product Line. Is there a fuction that allows to QV to reorganize the data to the desired format?

Current Format

Product Line A Revenue	Product Line B Revenue	Product Line C Revenue
$100	$50	$200

Desired Format

Product Line	Revenue
A	$100
B	$50
C	$200

Raw Data Format (Can QV Re-Organize?)

Anonymous — Mon, 27 Jun 2011 00:55:13 GMT

Hi Brian,

Is it an excel file?

You should be able to use crosstable to load this the way you want. However, you might have to manipulate the values "Product Line X Revenue" to parse it to just "X".

topic Raw Data Format (Can QV Re-Organize?) in QlikView

Raw Data Format (Can QV Re-Organize?)

Raw Data Format (Can QV Re-Organize?)