Budget vs Actual

[#1]

Dears,

i am a new in qlikview and i build the all sales dashboards and my manager ask me to add new dashboards that contain the (Budget & Actual) comparative and he needed by using bar charts ;so the issue is i have the years and i don't have the month what i have is a (periods(12 period (12 column))) and the data type for this columns is money , how can i use this 12 period as a month (Jan, Feb.....)

as what i know the bar chart need 1 Megars & 1 or to diminutions  ; i try to use Variables for each period and do Sum for this period and store it in each variable but i know it is not the solution ,

if any one have an idea pleeeeeeeeeeeease   tell me .......

and this is a sample from my data

[avinashelite]

Hi Ahmad,

Try to convert your 12 period column into row values

i.e eg

period1,perios2,...

10,20

30,60

to something like

period,value

period1,10

period2,20

period1,30

period2,60

so that you can use this period as the dimension in the charts.

to convert the columns into row use the

crosstable() function

[avinashelite]

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field name is the field to contain the attribute values.

data field name is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.

Examples:

Crosstable (Month, Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Hope this helps you