Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Budget vs Actual

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

2 Replies

Re: Budget vs Actual

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

Re: Budget vs Actual

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